Linked Server Query Problem -- sql server (alternate)

rlo NO[at]SPAM hiddenhearing.co.uk
4/7/2004 2:56:59 AM

Hi,

I'm getting errors when trying to run a query over linked servers that
works fine on a single server. The error text that comes up in QA is
as follows;

Server: Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'Qry1208'.
Server: Msg 125, Level 15, State 1, Line 1
Case expressions may only be nested to level 10.

Both servers are using same version SQL 2k, SP3 and (as far as I can
see) the level of nesting goes down 3 maybe 4 deep at the max?

Any help on this would be greatly appreciated.

sql NO[at]SPAM hayes.ch
4/8/2004 1:06:27 AM

[quoted text, click to view]

Perhaps you can post the query that works on a single server, and also
the version that doesn't work with a linked server? Also, if you're
using dynamic SQL, you should use PRINT or SELECT to view the query
string before you execute it, as sometimes it isn't what you expect.

sql server (alternate) : Linked Server Query Problem