Enable xp_cmdshell using sp_configure

Use Master

---- To allow advanced options to be changed.

EXEC sp_configure ‘show advanced options’, 1

GO

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

RECONFIGURE WITH OVERRIDE

GO

----- To enable the feature.

EXEC sp_configure ‘xp_cmdshell’, 1

GO

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

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure ‘show advanced options’, 0

RECONFIGURE WITH OVERRIDE

GO