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.
If advanced settings are not enabled at configuration level SQL Server will not let the user change the advanced features on server. An authorized user can turn on or turn off advance settings.
You can run the following command and check basic global configuration settings.
sp_CONFIGURE 'show advanced', 0 GO RECONFIGURE GO sp_CONFIGURE GO
You can run the following command and check advance global configuration settings.
sp_CONFIGURE 'show advanced', 1 GO RECONFIGURE GO sp_CONFIGURE GO
Here are a few recent related articles which you may be interested to learn:
- SQL SERVER – Check Advanced Server Configuration
- SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
- Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112
- SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
Please leave a comment with your experience with this settings as I am confident that other users would love to learn from your example.
Reference : Pinal Dave (https://blog.sqlauthority.com)
I enabled these in our development server to test extracting files from varbinary file data, which worked. Before I carry this to client facing environments, are these options safe to keep enabled? Do they pose any security risks to either the SQL server, or file system it would read from and write to?
sp_configure ‘show advanced options’, 1;
sp_configure ‘Ole Automation Procedures’, 1;