var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Resetting User password
How do I reset a users password ?
connect to isql and user following...
sp_password "caller's password","new password","userid"
here caller's password means the password of the user you used to connect to the isql
What if we do not know the callers password.
( I have reset it, But wanted to know what is the best process).
Originally Posted by perl
see the last line
here caller's password means the password of the user you used to connect to the isql --- now, how is that you dont know the password of the user by which you loggged in !!!
You need to log in as a user with sso_role, and run sp_password with the current users's password, the new password for the login that you are resetting, and that login name:
isql -Usa -Ptoto -SMYSRV
1> sp_password toto, new_passwd, the_user