error

30 Jun 2005 10:49 PM

Fab

I get the following error when i try to run a query on a linked server.

Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
SQLSTATE
HY007 (Error 0). The step failed.

any good ideas on how to solve?

1 Jul 2005 7:48 AM

John Bell

Hi

You may want to profile this to find out where it is occurring.
Could be something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116

John

Show quote

"Fab" wrote:

> I get the following error when i try to run a query on a linked server.
>
> Executed as user: Job Owner. SQL Web Assistant: Could not execute the SQL
> statement. SQLSTATE 42000 (Error 16805) Associated statement is not prepared
> SQLSTATE
> HY007 (Error 0). The step failed.
>
> any good ideas on how to solve?
>
>
>
>