ALTER LOGIN (bSQL) | Blockpoint Docs
Changes the password for the specified login.
Syntax​
ALTER LOGIN login_name PASSWORD="new_password"
Arguments​
login_name
Specifies the login to change.
new_password
A case-sensitive password.
Permissions​
To run this command you need one or more of these permissions:
MANAGEMENT permissions required on the master database.
MANAGEMENT permissions default to members of the admin fixed database role. Members of the admin fixed database role can transfer permissions to logins and users.
Remarks​
Changing a password will not have any effect on current connections and will only take effect on the next login.
Examples​
Change a password.​
The following example changes the system password to orangeKitten.
ALTER LOGIN system PASSWORD = "orangeKitten";