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 mastergosp_configure 'show advanced options',1reconfigure with overridegosp_configure 'xp_cmdshell', 1reconfigure with overridego