sql server远程查询语句

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

SELECT * FROM OPENROWSET('SQLOLEDB','服务器地址';'用户名';'密码',表名)

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