SQLTeam.com | Weblogs | Forums

How to work in more than one sql server at a time


My database is in SQL 2000 and I am working in SQL 2012. My new database is in SQL 2012. I want to link these two databases to get desired reports from these databases. I don't know how to do. Can you help me please?


use Linked Server

After you have setup Linked Server, you can access the remote server using 4 part naming like

SELECT * FROM [server_2].[database name].[dbo].[table name]