insert into table1
select * from opendatasource('SQLOLEDB', 'Data Source=192.168.1.100;User ID=sa;Password=12345').dbname.dbo.table1
执行上述可能SQL Server 阻止了对组件 \'Ad Hoc Distributed Queries\' 的访问
开启
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
关闭
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
select * from opendatasource('SQLOLEDB', 'Data Source=192.168.1.100;User ID=sa;Password=12345').dbname.dbo.table1
执行上述可能SQL Server 阻止了对组件 \'Ad Hoc Distributed Queries\' 的访问
开启
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
关闭
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure