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.

SQL SERVER - SP_CONFIGURE - Displays or Changes Global Configuration Settings globalconfig

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:

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)

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security
Previous Post
SQL SERVER – 2008 – User Account – sa or sysadmin
Next Post
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

Related Posts

1 Comment. Leave new

  • 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;
    GO
    RECONFIGURE;
    GO
    sp_configure ‘Ole Automation Procedures’, 1;
    GO
    RECONFIGURE;
    GO

    Reply

Leave a Reply