--远程操作数据库SQL语句
exec sp_addlinkedserver 'ITSV ', ' ', 'SQLOLEDB ', '211.81.251.85 '
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'sa', 'sa'
select * from ITSV.VirtualLab.dbo.tbl_user
exec sp_dropserver 'ITSV ', 'droplogins '
--远程操作数据库SQL语句
exec sp_addlinkedserver 'ITSV ', ' ', 'SQLOLEDB ', '211.81.251.85 '
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'sa', 'sa'
select * from ITSV.VirtualLab.dbo.tbl_user
exec sp_dropserver 'ITSV ', 'droplogins '