- 启用高级向导
- EXEC sp_configure 'show advanced options',1
RECONFIGURE
- EXEC sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE
- EXEC sp_configure 'show advanced options',1
- 跨域查询
- SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=数据源IP; User ID=sa; Password=XXX').DataBase.dbo.tableName
- SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=数据源IP; User ID=sa; Password=XXX').DataBase.dbo.tableName
- 关闭高级向导
- EXEC sp_configure 'Ad Hoc Distributed Queries',0
RECONFIGURE
EXEC sp_configure 'show advanced options',0
RECONFIGURE
- EXEC sp_configure 'Ad Hoc Distributed Queries',0
SQL SERVER 跨域方法
最新推荐文章于 2023-02-16 11:18:50 发布