/*** CREATING LINKED SERVERS***/ -- drop Linked servers if exist IF EXISTS(SELECT name FROM sys.servers WHERE name = N'AVSERVER\MBWIN') Exec sp_dropserver 'AVSERVER\MBWIN', 'droplogins' go IF EXISTS(SELECT name FROM sys.servers WHERE name = N'SWSERVER\MBWIN') Exec sp_dropserver 'SWSERVER\MBWIN', 'droplogins' go -- this will create a link with servers as specified EXEC sp_addlinkedserver @server='AVSERVER\MBWIN', @srvproduct='', --@provider='SQLNCLI', --'SQLOLEDB' @provider='SQLOLEDB', @datasrc='AVSERVER' EXEC sp_addlinkedsrvlogin @useself='FALSE', @rmtsrvname='AVSERVER\MBWIN', @rmtuser='sa', @rmtpassword='mbwin' go PRINT 'LINKING TO SWSERVER FOR SEOUL TRANSACTIONS...' GO EXEC sp_addlinkedserver @server='SWSERVER\MBWIN', @srvproduct='', --@provider='SQLNCLI', --'SQLOLEDB' @provider='SQLOLEDB', @datasrc='SWSERVER' EXEC sp_addlinkedsrvlogin @useself='FALSE', @rmtsrvname='SWSERVER\MBWIN', @rmtuser='sa', @rmtpassword='mbwin' go PRINT 'LINKED SERVERS STABLISHED...' GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)