Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Server 2000 Select clause

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-23 : 09:07:04
Rob writes "I am trying to select records from a table located in a database on a different server than the one I am calling from. For some reason, I can't get the syntax right."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-23 : 09:09:58
You need to make use of any of these
1 Linked Server
2 OpenRowSet

Refer SQL Server help file for more information


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -