今天用到的操作另一台服务器的数据库

--启用Ad Hoc Distributed Queries：
exec sp_configure 'show advanced options',1 
reconfigure 
exec sp_configure 'Ad Hoc Distributed Queries',1 
reconfigure 

--关闭Ad Hoc Distributed Queries：
exec sp_configure 'show advanced options',0 
reconfigure 
exec sp_configure 'Ad Hoc Distributed Queries',0 
reconfigure 

--把服务器的数据插入到本地

Insert Into QueryCallRecord
SELECT Time, ContactName, ContactPhoneNumber, Model, Dealer, Location FROM opendatasource( 'SQLOLEDB ',  'Data Source=10.167.65.38;User ID=fujitsu;Password=fujitsu').SannerWarranty.dbo.QueryCallRecord

Insert Into ScannerRecognizeRecord
SELECT Time, ContactName, ContactAddress, ContactPhone, PartNumber, SerialNumber, ModelNumber, MarkNumber, PurchaseDate, ProductionDate, PurchaseWay, Delar, QueryResult FROM opendatasource( 'SQLOLEDB ',  'Data Source=10.167.65.38;User ID=fujitsu;Password=fujitsu').SannerWarranty.dbo.ScannerRecognizeRecord