sp_configure

EXEC sp_configure 'show advanced options', 1
GO

sp_configure

EXEC sp_configure 'xp_cmdshell', 1
GO
==========================================================
USE master;
GO
EXEC sp_configure 'show advanced option', '1';


=================================
RECONFIGURE;
EXEC sp_configure;


==========================
USE master;
GO
EXEC sp_configure 'recovery interval', '3';
RECONFIGURE WITH OVERRIDE;
========================================
DAC
======
sp_configure 'remote admin connections', 1

reconfigure with override