• Hope that the naming convention when creating stored procedure must not be sp_ it should usp_ or whatsoever, but not sp_. What is the implications? It might have a performance degradation due to systems stored procedures name will start also sp_. SQL server will try to look first on the systems stored procedure first before users created procedure. But maybe the stored procedure that you created has some reasons why you do it that way. 🙂