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 2008/2005/2000 always have many feature which can be enabled or disabled. One should atleast know what are the options SQL Server provides.

If advanced settings are not enabled at configuration level SQL Server will not let user change the advanced features on server. Authorized user can turn on or turn off advance settings.

You can run following command and check basic global configuration settings.

sp_CONFIGURE 'show advanced', 0
GO
RECONFIGURE
GO
sp_CONFIGURE
GO

You can run following command and check advance global configuration settings.

sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE
GO

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

4 thoughts on “SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings

  1. Pingback: SQL SERVER - 2008 - Interview Questions and Answers - Part 5 Journey to SQL Authority with Pinal Dave

  2. Pingback: SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 10 of 31 Journey to SQLAuthority

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #037 | Journey to SQL Authority with Pinal Dave

  4. Pingback: SQL SERVER – SSMS: Server Dashboard Report | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s