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

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

--如果要禁用，

-- 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 disable the feature.

EXEC sp_configure 'xp_cmdshell', 0

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

-- To update the currently configured value for advanced options.

RECONFIGURE

GO