SQL remote server

[imadmarie]

dear all,

im trying to run a query against a remote server, the query uses the LEFT OUTER JOIN method, the query would run correctly, it doesnt return all correct rows, it seems this is a bug in SQL,

any help ?

 

[tlbroadbent]

I don't think we can help. At least, I can't. I'm not psychic. You must give us more information.

Tell us the version of SQL Server you use and the service pack you have installed.

Is the remote server also SQL Server? If so, is it the same version? Is the server linked?

How are you running the query? Are you using SQL Server Query Analyzer or another client? Are you running the query from a workstation or on the server?

Can you post the actual SQL code? Can you give a sample of the data in the tables? Can you tell us the result you get from the query and the result you think you should get? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.