代码 exec sp_configure &＃39;show advanced options&＃39;,1
reconfigure
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,1
reconfigure
GO
SELECT * into #tempxx FROM openrowset(&＃39;SQLOLEDB&＃39;,&＃39;服务器&＃39;;&＃39;登录用户&＃39;;&＃39;密码&＃39;,&＃39;SELECT * FROM athletic.dbo.imatposcheckOnlineHD&＃39;);
GO
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,0
reconfigure
exec sp_configure &＃39;show advanced options&＃39;,0
reconfigure
reconfigure
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,1
reconfigure
GO
SELECT * into #tempxx FROM openrowset(&＃39;SQLOLEDB&＃39;,&＃39;服务器&＃39;;&＃39;登录用户&＃39;;&＃39;密码&＃39;,&＃39;SELECT * FROM athletic.dbo.imatposcheckOnlineHD&＃39;);
GO
exec sp_configure &＃39;Ad Hoc Distributed Queries&＃39;,0
reconfigure
exec sp_configure &＃39;show advanced options&＃39;,0
reconfigure
京公网安备 11010802041100号