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 I was a bit afraid to write this article.

In any case, walking into a new client's site - I'm just happy if they are actually following any convention in the first place (and if they are sticking to it).  Usually I find that this is almost never the case.

Best Regards,

Joe