sp_dropapprole (Transact-SQL)
SQL Server 2005
Removes an application role from the current database.
 Important: |
|---|
| 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. |
Transact-SQL Syntax Conventions
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.
