sp_dropgroup (Transact-SQL)
SQL Server 2005
Removes a role from the current database.
 Important: |
|---|
| sp_dropgroup provides compatibility with earlier versions of Microsoft SQL Server. This feature will be removed in the next 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 ROLE instead. |
Transact-SQL Syntax Conventions
sp_dropgroup calls DROP ROLE. This is the preferred way to remove a role. For information about removing a role from the database, see DROP ROLE (Transact-SQL).
sp_dropgroup cannot be executed within a user-defined transaction.
