1:
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]2:在enterprise manager里的安全性-》链接服务器里查看
sp_dropserver [ @server = ] 'server'
[ , [ @droplogins = ] { 'droplogins' | NULL} ]2:在enterprise manager里的安全性-》链接服务器里查看
EXEC sp_addlinkedserver '192.168.18.37'exec sp_addlinkedsrvlogin @rmtsrvname = '192.168.18.37',
@useself = false ,
@locallogin = 'sa',
@rmtuser = '远端用户名' ,
@rmtpassword = '远端密码'2、本地用sa登陆执行:
select * from [192.168.18.37].pubs.dbo.jobs3、删除:
sp_droplinkedsrvlogin @rmtsrvname = '192.168.18.37', @locallogin = 'sa'
go
sp_dropserver '192.168.18.37'
GO