SQL Server Performance Forum – Threads Archive

Query Multiple Servers

SQL 2000 Servers: DB1 & DB2 DB1 –> replicates a database to DB2
DB1 has DB2 as a remote server (not a linked server) I need to run a query on DB1 that references a db table in DB2 Adding DB2 on DB1 as a linked server fails because it say’s it’s already there. what do I have to do to make this work ?

http://www.sql-server-performance.com/rd_osql.asp to manage query on multiple servers. What was the process involved while creating linked server connections, and what was the error? http://www.databasejournal.com/features/mssql/article.php/3085211 using linked server concept. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

using EM i tried to add a server that was a remotes server (due to replication) as a linked server and it said it was already defined.

Don’t define your linked server as SQL Server. You can only have one linked server with the same name. Make a linked server using the OLE SQL Server driver. Point it to the appropriate server, but call it "server_2" for example. You can then do whatever you need to do by using that. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

]]>