Thursday, July 25, 2013

Selecting data from two different servers in SQL Server

exec sp_addlinkedserver @server = 'MainServer'

select * from [MainServer].[TestDB].[dbo].[Emp]

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)