SQL创建DBlink

USE
master
EXEC master.dbo.sp_addlinkedserver @server = '192.168.1.1', @srvproduct='SQL Server'EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname='192.168.1.1',@useself='False',@locallogin=NULL,@rmtuser='sa',@rmtpassword='123'
GO