turn on 'xp_cmdshell'

SQLServerblockedaccesstoproceduresys.xp_cmdshellofcomponentxp_cmdshellbecausethiscomponentisturnedoffaspartofthesecurityconfigurationforthisserver.Asystemadministratorcanenabletheuseofxp_cmdshellbyusingsp_configure. Refer:http://msdn.micros

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure.

Refer:  http://msdn.microsoft.com/en-us/library/ms190693(SQL.90).aspx

源码与演示：源码出处

use master
go
sp_configure 'show advanced options',1
reconfigure with override
go
sp_configure 'xp_cmdshell', 1
reconfigure with override
go