Chandrashekar
5/7/2019 - 9:26 AM

Add Linked Database Server(Link DB)

Add Linked DB Server
content_copyfile_download

select * from sys.servers

--Link the server
exec sp_addlinkedserver @server = 'ServerName'
--Add Server Credentials
EXEC sp_addlinkedsrvlogin 'ServerName', 'false', NULL, 'sa', 'password'

select top 1 * from [ServerName].[DbName].[dbo].[TableName]

sp_dropserver 'ServerName', 'droplogins';