I want to change de user role by executing a stored procedure containing

the folowing command: Exec sp_setapprole 'testrole', 'testrole'

The stored procedure is called from a ASP page. SQL-server gives the

folowing error message: "Application roles can only be activated at the ad

hoc level."

I get the same error message when I execute the stored procedure within

the SQL Query Analyser. But when I execute the command not within the

stored procedure (Exec sp_setapprole 'testrole', 'testrole') everything

goes well. But then I get the same error if this is done in a ASP page.



Somebody knows what the problem maybe, and how to do this?



Thanks in advance.