Application Roles - Changing Password

Hello,

 

in SQL Server 2005 I have an application role that is being used to limit access to my server data from third party applications. Everything is working well, except changing the Application role password.

I set up a small form that allows an administrator to change the App Role password through the front end app. I cannot, however, seem to get the Password field in my approle to accept a parameter.

For example:

declare @newpassword varchar(128)

set @newpassword = 'foo'

ALTER APPLICATION ROLE MyApplicationRole

with PASSWORD = @newpassword

This procedure gives me a syntax error in the last line. It will accept a string in quotes but not a varchar parameter.

 

Ideas?