insert into table select * from opendatasource (‘sqloledb’, ‘data source=172.168.44.146;user id=sa;password=123’ ).table
exec sp_configure ‘show advanced options’,1
reconfigure
exec sp_configure ‘ad hoc distributed queries’,1
reconfigure
insert into table select * from opendatasource (‘sqloledb’, ‘data source=172.168.44.146;user id=sa;password=123’ ).table
exec sp_configure ‘show advanced options’,1
reconfigure
exec sp_configure ‘ad hoc distributed queries’,1
reconfigure