Blog

Avoiding prefix 'sp_' in the name of user stored procedure

By Venkatesan Jayakantham May 10 2012
Avoiding prefix 'sp_' in the name of user stored procedure in SQL Server
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 1.7k
  • 0

By nature, if the stored procedure is created with the prefix sp_. SQL Server will start search for the stored procedure in the master database. After wards, it will search for the local database which in turn a major problem. To avoid this,

 

We need to access the stored procedure using Fully Qualified Name,  

 

                        DatabaseName.SchemaName.ProcedureName