sql2005 OPENDATASOURCE 需要Ad Hoc Distributed Quer
标签： sql2005 OPENDATASOURCE 需要Ad Hoc Distributed Quer 博客 51CTO博客
2023-04-17 18:23:53 208浏览
sql2005 OPENDATASOURCE 需要Ad Hoc Distributed Quer，execsp_configure'showadvancedoptions',1reconfigureexecsp_configure'AdHocDistributedQueries',1reconfigureGOSELECT*FROMOPENDATASOURCE('SQLOLEDB','DataSource=192.168.1.100,1433
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
GO
SELECT *
FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.1.100,1433;User ID=sa;Password=sa').msdb.dbo.backupfile
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure好博客就要一起分享哦！分享海报
此处可发布评论
评论（0）展开评论
暂无评论，快来写一下吧
展开评论
您可能感兴趣的博客
