HOW TO ENABLE xp_cmdshell AND OTHER ADVANCED OPTIONS (T-SQL)

This is pretty old for me, but it might be very helpful for anyone. There is no need for too much explanation here, but only one note here: if the script doesn't work, try to execute statements one by one.

EXEC sp_configure 'show advanced options', 1

GO

/*

I received this message:

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

*/

RECONFIGURE

GO

EXEC sp_configure

/*

Perfect! This list all interesting options here...

*/

GO

/*Let's take this one:*/

EXEC sp_configure 'xp_cmdshell', 1

/*

Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install.

*/

GO

RECONFIGURE

Mike C.