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