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