SQL SERVER – Check Advanced Server Configuration

I was recently asked following question:“How I check all the advanced configuration of the SQL Server?”EXEC sp_configure 'Show Advanced Options', 1;GORECONFIGURE;GOEXEC sp_configure; Running above script will return all the advanced server configurations.Read more: Journey to SQL Authority with Pinal Dave Posted via email from .NET Info