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

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

Venkatesan Jayakantham

I am Venkatesan Prabu Jayakantham(SQL Server DBA and Dotnet developer) from India (Tamil Nadu). A Microsoft SQL Server MVP,MCITP,MCTS,MCAD,CCNA,QAI certified Expert.  I am a Mindcracker MVP for the year 2010. &nbs... Read more

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.

Latest Blogs