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 |
|
sql_wedge
Starting Member
18 Posts |
 Posted - 2005-08-11 : 05:55:46
|
| There are 3 sql servers on my network server1,server2,server3.If I have query analyzer open on server1, how can I access a table on server3?i.e select * from server3..databasename3.tablename3? -- this is wrong! |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2005-08-11 : 06:00:25
|
| u need to add linked servers for server2 and server3 on server1 for more help on adding linked servers check bol under sp_addlinkedserverHe is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.comhttp://www.sqljunkies.com/weblog/sqldude |
 |
|
|
|
|
|
Select query to remote database