A quick post on how to enable xp_cmdshell on Sql 2005/2008/2008R2
EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘xp_cmdshell’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘show advanced options’, 0
GO
RECONFIGURE
GO
Done.