Where I work, we follow a naming convention to what Michael Hotek proposes. Here's the link to the article on his site:

http://www.mssqlserver.com/articles/naming_conventions_p1.asp

K. Brian Kelley

bkelley@agfirst.com