-------------------------------------------------------
-- SQL 2008 Configuration mod to ALLOW xp_cmdshell for PING
-- TB
-- 2009/10/01
-------------------------------------------------------


EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

-- To enable the feature.

EXEC sp_configure 'xp_cmdshell', 1

GO

-- To update the currently configured value for this feature.

RECONFIGURE

GO 
