sql server启用show advanced options和Ad Hoc Distributed Queries
分类:sql server 人气:1156 评论:0 时间:2010-03-01 12:55
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
go
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE WITH OVERRIDE
go
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE