RonKyle (7/7/2008)
I would recommend as a MINIMUM that all the stored procs you create be abbreviated usp_ for "user stored procedure." Not only does that avoid the sp_ issue but it keeps your stored procs seperate.
That is an excellent idea. I have extended it to use asp_ for administrator only stored procedures that the user will never use.