Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Does anybody know where I can find a list of all the parameter options for sp_configure? It isn't really jumping out at me when I search online for possible variations and the capabilities of sp_configure.


share|improve this question
up vote 6 down vote accepted

At least three times on the sp_configure page, you have "Setting Server Configuration Options".

  • In the table for the row "config_value"
  • Under "Advanced Options"
  • At the bottom

This page also shows what happens if you run sp_configure with a blank @configname

If not specified, the complete list of options is returned.

This applies from SQL Server 2000 to SQL Server 2008 pages

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.