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:
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'
Upon successful query execution, the result will show the following message as in image above.
Now when I execute the query sp_configure, I see many result rows.
Many other syntax and features about sp_configure are documented in MS article. Hope this will be helpful.
Source: Ashwani Ashwin