Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Removes an application role from 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 DROP APPLICATION ROLE instead.
Applies to: SQL Server (SQL Server 2008 through current version).
sp_dropapprole can only be used to remove application roles. If a role owns any securables, the role cannot be dropped. Before dropping an application role that owns securables, you must first transfer ownership of the securables, or drop them.
sp_dropapprole cannot be executed within a user-defined transaction.
The following example removes the SalesApp application role from the current database.
EXEC sp_dropapprole 'SalesApp';