how to access datas across 2 servers
Database
2
Posts
2
Posters
0
Views
1
Watching
-
hi, i am having 2 tables (SQL 2000) on 2 different servers (windows 2003 server). now i have to run some inner join on both the tables. i tried by giving select * from servername1.databasename.dbo.tablename kind of statements in the servername2. but it throws errors. kindly suggest. thanks
-
hi, i am having 2 tables (SQL 2000) on 2 different servers (windows 2003 server). now i have to run some inner join on both the tables. i tried by giving select * from servername1.databasename.dbo.tablename kind of statements in the servername2. but it throws errors. kindly suggest. thanks
You need to add the remote server as a linked server. Check : sp_addlinkedserver[^]
Hesham A. Amin blog