Do not preface your stored proc. names with sp_, because doing so reduces performance. When you call a stored procedure that starts with sp_ , SQL Server always checks the master database first even if the stored Procedure is quilfied with the database name.
Microsoft Patterns and Practices Team
