Join tables from different server

[Naunt]

Dear All, Please help me to JOIN 2 table from different server. Thank you.

[Covean]

1. Some "more" (more than JOIN) information would help. 2. Read the guidelines at the top of this page. 3. Where is the question?

Greetings Covean

[CitrusTech]

So idea of what databases you're working with would help.

Dave Decision Tree Software

[J4amieC]

naunt wrote:

Please help me to JOIN 2 table from different server.

Infrastructure/Environment fail. Now, to answer your question; execute sp_addlinkedserver[^] to link the two servers, then using the server name to fully qualify a table, write a join in the normal way. This post assumes MS SQL Server.

[Naunt]

Thank you for your reply. I am really really sorry for my uncomplete question. I am using SQL server 2000. @J4amieC, Thank you. Will try with "sp_addlinkedserver[^]".