New Information - SQL Server 2000 SP3.
Changes the password of an application role in the current database.
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. The new password is encrypted when stored in the Microsoft® SQL Server™ system tables. password cannot be NULL.
Security Note Do not use a NULL password. Use a strong password. For more information, see Security Rules.
Return Code Values
0 (success) or 1 (failure)
sp_approlepassword cannot be executed within a user-defined transaction.
Only members of the sysadmin fixed server role, and the db_securityadmin and db_owner fixed database roles can execute sp_approlepassword.
This example sets the password for the PayrollAppRole application role to "B3r12-36".
EXEC sp_approlepassword 'PayrollAppRole', 'B3r12-36'