SQL Server 2005 2208 xp_cmdshell存储过程 默认禁用了,用下面的语句可以打开和禁用。
摘要: --SQL语句开xp_cmdshell
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
-- To disallow advanced options to be changed.
EXEC sp_configure 'show advanced options', 0
GO
<
阅读全文
posted @
2013-03-07 16:00 聂文龙 阅读(575) |
评论 (0) 编辑