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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-20 : 08:29:44
|
| prasad writes "I would like to select rows in a particular database and a table that is residing in a different server. Please tell me how to do it." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-20 : 08:52:31
|
| You need to create a linked server (you can do this through Enterprise Manager or with sp_addlinkedserver and sp_addlinkedsrvlogin system stored procedures). Once you have your linked server set up, you can reference the remote table, using the four part naming convention:server.database.owner.table |
 |
|
|
|
|
|
selecting rows between two sqlservers