I wrote this article a couple of years ago (back in 2003) - so I was wondering why I was getting emails on this all of the sudden!

Chris - this is an excellent article. Great work!

A few thoughts...

First off - I don't think the author intentionally wanted to set off this wave of discussion.  He's probably a bright guy who wrote this completely off-the-cuff, and...

Charles - I agree 100%.  There are many workable standards out there - but the best one is having one and sticking with it.

At first I was worried about putting...

Wangkhar,

With the correct scripting or migration tools, explicit constraint names aren't necessary.  I don't object to constraint naming conventions - but I find that for a team of developers and dbas,...

Hi,

I figured this article would get some discussion!  I like the usp_ convention - but I know of those who do not.  100 DBAs = 100 Naming conventions.  That was why...

Hi All,

One common question I get about this article is about the email not working.  The article's example assumes you have a valid, open relay SMTP service running from your...

I'm sure with Yukon we'll learn if this (Information_Schema views) was an idea that will die on the vine. In the meantime, Books Online indicates that this is the...

From the Author: My apologies for the Transact-SQL formating. The code examples work fine - they just look a little strange.

Just an addendum to my article - for the

"INSERT #Errors EXEC xp_readerrorlog", this extended proc is in the master database... So change it to:

INSERT #Errors EXEC master..xp_readerrorlog

Also - remember...