• Not sure if this is a huge problem. Could lead to some confusion and Brian has good points. In general, if you do not need a stored procedure executed from master (regardless of in which db you need it run), don't use sp_. I use spXXXXXXX for mine. Some people use usp_, mysp_, etc.

    It's a personal opinion, but I avoid sp_

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones