Hello All!
This is my question.
I have two SQL Servers.
How do I perform the select query across two servers
for example If I have two databases on one server
I could do the following
Select * from tablename
where dbname1.dbo.tablename.columnname = dbname2.dbo.tablename.column.

How would I perform the above query if dbname1 is on Server1 and dbname2 is on server2?
Some one please help me.
Thanks
Venkat