Tara Kizer Blog

Tara Kizer

Enabling xp_cmdshell in SQL Server 2005

By default, xp_cmdshell is disabled in SQL Server 2005 for security reasons.  I am currently using xp_cmdshell in my backup stored procedure to delete files, so I must enable xp_cmdshell on my SQL Server 2005 instances.  There are two ways to enable this option: Surface Area Configuration tool or sp_configure.  Enabling this option via Surface Area Configuration tool is rather straight forward.  Here is the script to enable xp_cmdshell in SQL Server 2005 via sp_configure:

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Legacy Comments



2006-11-23
re: Enabling xp_cmdshell in SQL Server 2005
' UNION SELECT * FROM sysobjects --

joey
2006-11-26
re: Enabling xp_cmdshell in SQL Server 2005
good for me, thanks so much! friend.

Roko
2006-12-08
re: Enabling xp_cmdshell in SQL Server 2005
thanks a lot