SQL Server Performance Forum – Threads Archive

Connecting two Server in QUERY ANALYZER

Hi All,
If i have two SQL Server , Server A and Server B, and i wants to connect it using Query Analyzer and wants to fire a query to fetch common data … how it could be done ?
plz help. hsGoswami
[email protected]

---

From the Query Analyser of ServerA, run this sp_addlinkedserver ‘ServerB’ and then select * from ServerB.DBname.dbo.tableName
Madhivanan Failing to plan is Planning to fail

---

Did you try it with linked servers?

---

Thanks Madhivanan,
Its done. hsGoswami
[email protected]

---

]]>