exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure SELECT * into T_System_Organizati ...
exec sp_configure 'show advanced options',1 reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure
SELECT * into T_System_Organization_bak_20180308
from openrowset ('SQLOLEDB' , '10.***.***.***,埠 ; '用戶名' ; '密碼' ,[資料庫名稱].dbo.表名)
exec sp_configure 'Ad Hoc Distributed Queries',0 reconfigure
exec sp_configure 'show advanced options',0 reconfigure