• Instead of Person.sp_ReturnSomething, create proc with dbo prefix and it returns 5.

    I got it wrong as I don't have Adventureworks DB. But, with testing it and getting right would be cheating myself.

    Good question. Everyday is a learning day.

    SQL DBA.