Changes the password of an application role in the current database.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER APPLICATION ROLE instead.
|Applies to: SQL Server ( SQL Server 2008 through current version).|
sp_approlepassword [ @rolename= ] 'role' , [ @newpwd = ] 'password'
[ @rolename = ] 'role'
Is the name of the application role. Role is sysname, with no default. role must exist in the current database.
[ @newpwd = ] 'password'
Is the new password for the application role. password is sysname, with no default. password cannot be NULL.
Do not use a NULL password. Use a strong password. For more information, see Strong Passwords.
Return Code Values
0 (success) or 1 (failure)
sp_approlepassword cannot be executed within a user-defined transaction.
Requires ALTER ANY APPLICATION ROLE permission on the database.
The following example sets the password for the
PayrollAppRole application role to
EXEC sp_approlepassword 'PayrollAppRole', '''B3r12-36';