Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

Thanks!

share|improve this question
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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