Blog

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

Posted by Venkatesan Jayakantham Blogs | SQL May 10, 2012
Avoiding prefix 'sp_' in the name of user stored procedure in SQL Server

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

COMMENT USING
PREMIUM SPONSORS
Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.