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 |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-02-04 : 02:55:40
|
| i have two servers where i have logged in, hr and transport i want to write a query in query analyser of the hr server to retrieve information in the transport server. how will i do it i tried with select * from servername.databasename.permission.tablenamei get a messageServer: Msg 7202, Level 11, State 2, Line 1Could not find server 'transport' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-04 : 09:30:32
|
| add the linked server and Query |
 |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-02-05 : 09:56:06
|
I thought the error message might have given that one away ;)
George<3Engaged! |
|
|
|
|
|
|
query between different servers