Very good question, thank you Jason.

Creating a proc with name beginning with sp_ is very evil indeed. While there is a way to invoke the AdventureWorks' version of the proc by schema qualifying it, i.e.

exec Person.sp_ReturnSomething 5;

returns desired

Result

-----------

5

still beginning proc name with sp_ is ill advised for a very good reason.

Oleg