SQL Server跨服务器之间访问
时间:2022-03-14 02:41
在两个服务器都需要启用Ad Hoc Distributed Queries:
EXEC sp_configure ‘show advanced options‘, 1
RECONFIGURE
EXEC sp_configure ‘Ad Hoc Distributed Queries‘, 1
RECONFIGURE
然后就可以使用SQL内置函数访问:
SELECT *
FROM OPENDATASOURCE(‘SQLOLEDB‘,
‘Data Source=111.111.113.41;User ID=sa;Password=‘).ycfyhis.dbo.dictdept