Microsoft SQL Server Enable and show advanced options


Example

Exec sp_configure 'show advanced options' ,1
RECONFIGURE
GO
-- Show all configure
sp_configure