/*
--开启远程访问
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure*/
select * from openrowset('SQLOLEDB','IP';'用户名';'密码',库名.dbo.表名)
/*
--关闭远程访问
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure */
--开启远程访问
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure*/
select * from openrowset('SQLOLEDB','IP';'用户名';'密码',库名.dbo.表名)
/*
--关闭远程访问
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure */