Show all Hide all


Use this procedure to change a user's password rather than updating the password / passwordhash columns in adminuser directly.

Type: Stored procedure
Area of use: General use


@UserID mandatory int
@Password mandatory nvarchar(50)
If the text '#SAME#' then the password will be unchanged.

Since you can't know what a user's password was if it has been hashed this is useful in newedits where you have to set the default value of the password field. Remember to use CONVERT(nvarchar(50),'#SAME#') in the GetEditFields procedure.
@PasswordHasExpired optional bit
Set to 1 to force the user to change his password the next time he logs in. Defaults to 0.
Possible value Description
NULL Use current value.