I was recently asked following question about how to Check Advanced Server Configuration.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
It is very good to know our server and its feature which are available for configurations. SQL Server always has many features which can be enabled or disabled. One should at least know what are the options SQL Server provides. This blog post we will learn how to display or change global configuration settings.