usp_ instead of sp_ as default stored procedure prefix?


Should the default stored procedure prefix be sp_ ? Correct me if I'm wrong, but I thought Microsoft doesn't like user-defined stored procedures that start with sp_. Perhaps the out-of-the-box default stored procedure prefix should be something like usp_ instead of sp_?


pbolduc wrote May 28, 2008 at 5:42 PM

This is already a configurable item in the settings. Your stored procedures can start with 'sp_' if you like, however, it is not recommended. The reason is that when SQL Server attempts to execute a stored procedures that start with 'sp_', it will scan the master database first to resolve. By avoiding the 'sp_' prefix, you avoid the performance impact of scanning the master database.

wrote Oct 23, 2008 at 1:25 PM

wrote Feb 14, 2013 at 1:59 AM