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

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