SQL Server database link

-- Author: cxg
-- Todo: Remote Data Transmission (database link)
Bytes ---------------------------------------------------------------------------------------------------
-- Add remote server Link
-- Star MSDTC first
Execute sp_addmediaserver @ Server = '192. 168.0.45'
Execute sp_add1_srvlogin @ rmtsrvname = '192. 168.0.45 ',
@ Useself = false,
@ Locallogin = 'sa ',
@ Rmtuser = 'sa ',
@ Rmtpassword = NULL
Go
Bytes ---------------------------------------------------------------------------------------------------
Insert into [192.168.0.45]. pos_bak.dbo.unit select * From pos_yn.dbo.unit
Go
Bytes ---------------------------------------------------------------------------------------------------
-- Drop Remote Server Link
Execute sp_droplinkedsrvlogin @ rmtsrvname = '192. 168.0.45 ', @ locallogin = 'sa'
Execute sp_dropserver @ Server = '192. 168.0.45'
Go