|
執(zhí)行1. 為開啟所需服務(wù)；成功后執(zhí)行3.進(jìn)行導(dǎo)數(shù)據(jù)；執(zhí)行完后關(guān)閉服務(wù)，執(zhí)行2. 1.啟用Ad Hoc Distributed Queries： exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure 2.為了安全使用完成后，關(guān)閉Ad Hoc Distributed Queries： exec sp_configure 'Ad Hoc Distributed Queries',0 reconfigure exec sp_configure 'show advanced options',0 reconfigure 3. INSERT TPOLPDTPLNH SELECT * FROM OPENROWSET('SQLOLEDB','10.69.4.53\ebenefitqa';'dev';'developer',eCompassSGP132QA.DBO.TPOLPDTPLNH) |
|
|
