Avoid using sp_ as a prefix for stored procedures

In SQL Server, the sp_ prefix is reserved for system stored procedures. If you use sp_ prefix for your stored procedures, the name of your procedure might conflict with the name of a system stored procedure that exists or that will be created in the future, and in some cases SQL Server will execute the system procedure instead of your procedure.

Using an explicit schema qualifier when executing the stored procedure provides a slight performance advantage, because SQL Server does not have to search multiple schemas to find the procedure.

If the post helped you, please share it:
Pin It

1 comment to Avoid using sp_ as a prefix for stored procedures

  • Toussaint Houle

    Hello there, I found your blog via Google at the same time as looking for a related topic, your website came up, it appears great. I've bookmarked it in my google bookmarks.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">