Query from One Server to Another -- sql server clients

Steve Lowrance
4/21/2006 10:55:02 AM

How can I use Query on a client connected to one server when the query pulls
data from the connected server and from another server. Now we get an error
when the query attempts to read from the other server.

If we run the query directly on the first server, it pulls from the other

Sue Hoegemeier
4/25/2006 7:56:40 AM

That doesn't give us much to go on without knowing the
error, if you are using linked servers, openquery, or how
you are running whatever directly on the first server. The
best you can do is review the topics in books online related
to Linked Servers as well as Distributed Queries.

-Sue

On Fri, 21 Apr 2006 10:55:02 -0700, Steve Lowrance
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Query from One Server to Another