Stored procedure name starts with sp_

It is not recommended to start a user stored procedure name with sp_ as this prefix is used in built in stored procedures.

If you prefix a procedure name with ‘sp_’, the master database is searched first, which will be a performance hit. SQL Server identifiers should not have ‘hungarian notation’ prefixes.

Available in

SQL Prompt

SQL Code Guard

Didn't find what you were looking for?