MSSQL跨服务访问数据库 

--启动
EXEC SP_CONFIGURE 'show advanced options',1RECONFIGURE
EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries',1RECONFIGURE

--查询
SELECT [ID] FROM OPENDATASOURCE('SQLOLEDB','DataSource=.;User ID=sa;Password=sa').DBName.dbo.TableName

--关闭
EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries',0RECONFIGURE
EXEC SP_CONFIGURE 'show advanced options',0RECONFIGURE


 


 

 

posted @ 2015-08-10 15:23  ilmari  阅读(179)  评论(0)  编辑  收藏  举报