--判断是否开启远程操作服务，如果关闭，则开启，用完之后关闭

DECLARE @value SQL_VARIANT

SELECT @value=VALUE from sys.configurations WHERE NAME='show advanced options'

IF(@value=convert(sql_variant,0))

BEGIN

    EXEC sp_configure 'show advanced options',1

    RECONFIGURE

END

SELECT @value=VALUE from sys.configurations WHERE NAME='Ad Hoc Distributed Queries'

IF(@value=convert(sql_variant,0))

BEGIN

    exec sp_configure 'Ad Hoc Distributed Queries',1

    RECONFIGURE

END

SELECT * from OpenDataSource('SQLOLEDB','Data Source=192.168.35.6;User ID=sa;Password=server').[Test2.0].dbo.Userinfo

--关掉远程操作服务

exec sp_configure 'Ad Hoc Distributed Queries',0

RECONFIGURE

exec sp_configure 'show advanced options',0

RECONFIGURE