exec sp_configure ‘show advanced options’,1
reconfigure
exec sp_configure ‘Ad Hoc Distributed Queries’,1
reconfigure
select * into confdep1 from openrowset( 'SQLOLEDB ', '192.168.0.210 '; ‘select’; ‘select210’,xtfsdz.dbo.confdep)
exec sp_configure ‘show advanced options’,1
reconfigure
exec sp_configure ‘Ad Hoc Distributed Queries’,1
reconfigure
select * into confdep1 from openrowset( 'SQLOLEDB ', '192.168.0.210 '; ‘select’; ‘select210’,xtfsdz.dbo.confdep)