sp_password
[[@old =] 'old_password',]
[@new =] 'new_password'
[, [@loginame =] 'login']
@old | Original password of the login account (NULL means without the password; the default value is NULL). |
---|---|
@new | New password of the login account (NULL means without the password). |
@loginame | Name of the login account whose password will be changed (NULL means to change the password of the logged in account; the default value is NULL). |
EXEC sp_password 'reader', 'abcdef', 'pm_reader'
EXEC sp_password 'reader', NULL