>Some still name all stored procedures with an
sp_
prefix.
I do not recommend prefixing stored procedures with sp_. This prefix has special meaning to SQL Server - implying that the stored procedure is a system stored procedure and resides in the master database.
-Mike