Thanks. I am aware of the sp_password option. However you mentioned the application. If this is the way it needs to be done. How do you integrate this into the application side where the user is prompted to change it..?