Wednesday, January 31, 2007

Enable xp_cmdshell

With SQL Server 2005, xp_cmdshell is disabled by default

To enable this feature:

Option 1: Using T-SQL

--Enable the feature
EXEC sp_configure 'xp_cmdshell', 1
-- To update the currently configured value for this feature.

Option 2: SQL Server 2005 Surface Area Configuration tool

From Surface Area Configuration Tools -> Choose “Surface Area Configuration for Features” > Check “Enable xp_cmdshell”

No comments: