EXEC sp_addlinkedserver 'srv_lnk','','SQLOLEDB','ServerAddress'
EXEC sp_addlinkedsrvlogin 'srv_lnk','false',NULL,'sa','123456'
EXEC sp_serveroption 'srv_lnk','rpc out','true'
go
SELECT *
FROM srv_lnk.DBName.dbo.TableName
EXEC sp_dropserver 'srv_lnk','droplogins'
远程访问SQL数据库执行查询
最新推荐文章于 2023-11-21 16:28:00 发布