T-SQL Tuesday #3: SQL Server Relationships

Kalen Delaney — Tue, 09 Feb 2010 22:40:00 GMT

It's time for the third T-SQL Tuesday , managed this time by Rob Farley . I thought I wasn't going to make this deadline, since I have been swamped since the end of last week, and over the entire weekend. However, I've got a break with nothing urgent...(read more)

Did you know? -- Better than sp_configure

Kalen Delaney — Mon, 06 Nov 2006 21:06:00 GMT

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

Kalen Delaney : configuration

T-SQL Tuesday #3: SQL Server Relationships

Did you know? -- Better than sp_configure