Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Removes an application role from the current database.
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use DROP APPLICATION ROLE instead.
Transact-SQL syntax conventions
sp_dropapprole [ @rolename = ] N'rolename'
[ ; ]
The application role to remove. @rolename is sysname, with no default. @rolename must exist in the current database.
0 (success) or 1 (failure).
sp_dropapprole can only be used to remove application roles. If a role owns any securables, the role can't be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.
sp_dropapprole can't be executed within a user-defined transaction.
Requires ALTER ANY APPLICATION ROLE permission on the database.
The following example removes the SalesApp application role from the current database.
EXEC sp_dropapprole 'SalesApp';