MSSQL 跨数据库连接

MSSQL 跨数据库连接

SELECT * FROM opendatasource('sqloledb','data source=192.168.1.197;user id=sa;password=sa')
.SafetyMonitor3.dbo.Dictionary

 

 

 

解决办法：  --启用Ad Hoc Distributed Queries：新建查询，输入
      exec sp_configure 'show advanced options',1
      reconfigure
      exec sp_configure 'Ad Hoc Distributed Queries',1
       reconfigure
--使用完成后，关闭Ad Hoc Distributed Queries：
      exec sp_configure 'Ad Hoc Distributed Queries',0
      reconfigure
      exec sp_configure 'show advanced options',0
      reconfigure

posted on 2016-05-17 14:06  v.e.n.u.s 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/jx270/p/5501440.html