添加SQL链接服务器

EXEC master.dbo.sp_addlinkedserver @server = N'192.168.xxx.xxx', @srvproduct=N'DB_NAME', @provider=N'SQLOLEDB', @datasrc=N'192.168.xxx.xxx'
 
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'192.168.xxx.xxx', @locallogin =NULL, @useself = N'False', @rmtuser = N'YK_XXX', @rmtpassword = N'xxx'