SqlServer cross-server DML

There are three stored procedures: sp_addmediaserver Add Server link sp_javasservers query server link sp_dropserver Delete server link example: ----------------------------------------- first create connection server execsp_add1_serverinstance1, MSDASQL, NULL, N

There are three stored procedures: sp_addmediaserver Add Server link sp_javasservers query server link sp_dropserver Delete server link example: Login -- first create connection server EXEC sp_addmediaserver 'instance1', '', 'msdasql ', NULL, N

A total of three stored procedures

Sp_addmediaserver Add Server Link

Sp_linkedservers
Sp_dropserver Delete server Link

Example:

-------------------------------------

-- Create a linked server first
EXEC sp_addmediaserver
'Instance1 ',
'',
'Msdasql ',
NULL,
NULL,
'Driver = {SQL Server}; SERVER = 192.168.1.100; UID = sa; PWD = 123 ;'
GO

-- View linked servers
EXEC sp_incluservers

-- Delete a linked server
EXEC sp_dropserver 'instance1'

-- Start query Test
Select * from instance1.db1. dbo. table1
Select * from alias. Database Name. dbo. Table Name