Enable xp_cmdshell

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

Additional Interesting Articles

VB.net Regex Example In SSIS
C# Needle In Haystack String Replacements
Email Process
Email Deliverability at AOL
Common Phrases Used In SPAM
Looping Through a SQL Result in C#

©2008 AndrewKimball.com