The requirement is like this

1. The front end application will call a stored procedure.

2. Inside the stored procedure, I have to change the password.

How to get it, done. What is the script you have mentioned. Can you please explain a little bit more.