SQL远程服务器操作数据

exec sp_addlinkedserver 'RemoteServer','','SQLOLEDB','192.168.2.2,2434'
Exec sp_addlinkedsrvlogin 'RemoteServer','false',null,'sa','932kj'
GO

Select * From RemoteServer.master.dbo.spt_monitor
GO


EXEC sp_dropserver 'RemoteServer', 'droplogins'
GO