>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