THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Did you know? -- Better than sp_configure

I’ve mentioned before that the new metadata is so voluminous that I’ve barely skimmed the surface. Last week in class in Minneapolis ( one of my students discovered an alternative to sp_configure. You’re probably aware that by default, even if you’re logged in as someone in the sysadmin group, you can’t see all the configuration options until you enable show advanced options. However, if you select from the new metadata view sys.configurations, you can see all the values, and their settings, regardless of your show advanced options setting.


SELECT * FROM sys.configurations


In addition, this view shows for each option if it is dynamic, and if it is advanced.


Have fun!


-- Kalen

Published Monday, November 6, 2006 2:06 PM by Kalen Delaney
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Cristian Lefter, SQL Server MVP said:

And similar you can use the sys.system_components_surface_area_configuration catalog view to retrieve the options configurable by the Surface Area Configuration tool.
November 7, 2006 3:05 AM

Kalen Delaney said:

Thanks, Christian! This is great to know.
I don't see anything about enabling CLR in the list of components and objects. Maybe it's just hiding somewhere.
November 7, 2006 7:58 AM

Leave a Comment


This Blog


Favorite Non-technical Sites or Blogs

Privacy Statement