I’ve mentioned before that the new metadata is so voluminous that I’ve barely skimmed the surface. Last week in class in Minneapolis (www.nhmn.com) 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