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-02-08 : 09:45:03
|
| Prabha writes "Hi friends this is my prob. i hve two sql servers in the same domain. Server1(S1) has a table called t1 in the database (S1db)and server2(S2) has a table called t2 in the S2db. i am using the machine Server1, i would like to access table t2 from the server S2 with sql statemets.Server2(S2 is registered as a client in S1).thankz in advancePrabha." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 09:47:22
|
| This looks like a job for....linked servers!If you look in Books Online under "linked servers" and "OPENQUERY", you'll find a lot of information on setting up a linked server, and querying it. There are some settings you need to set properly for linked servers to work, I recommend you read the entries as much as possible. It'll help in case you have to tweak it a little. |
 |
|
|
|
|
|
Accessing diffrent server with sql query