今天的业务涉及到了跨服务器链接数据 且 需要将远程数据插入到本地。特记录，以供学习..备份
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
select * into hyye_info from openrowset( 'SQLOLEDB ', '192.168.0.233'; 'sa'; 'sa',远程数据库名称.dbo.hyye_info)
exec sp_configure 'Ad Hoc Distributed Queries',
reconfigure
exec sp_configure 'show advanced options',
reconfigure
