sp_password cannot be executed within a user defined transaction. (Ref SQL Books online). You can exucute sp_password

All the best

DEGA