SQL / SSRS
List all advanced configuration options in MSSQL with sp_configure
Category: Microsoft Dynamics 365,SQL / SSRS Author: Ashwani Ashwin Date: 1 year ago Comments: 0

Hello Everyone,

While writing the Technical document, we all would need to specify the configuration options details of the SQL Server which was Installed on Dynamics Server along with the version and the Instance Name.

 

The SQL configuration options can be fetched from the master table using the query:

Exec sp_configure

sp_configure_1

 

However, this is not all the options. To show all the advanced options need to run the following query:

1. EXEC sp_configure 'show advanced option', '1'

sp_configure_2

Upon successful query execution, the result will show the following message as in image above.

 

2. RECONFIGURE; 

sp_configure_3

 

Now when I execute the query sp_configure, I see many result rows.

sp_configure_4

 

Many other syntax and features about sp_configure are documented in MS article. Hope this will be helpful.

Thanks ! ?

Source: Ashwani Ashwin