sp_dropgroup (Transact-SQL)

Removes a role from the current database.

Transact-SQL Syntax Conventions

sp_dropgroup [ @rolename = ] 'role'

• [ @rolename = ] 'role'
  Is the role to remove from the current database. role is sysname, with no default.

0 (success) or 1 (failure)

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.

Requires CONTROL permission on the role or ALTER ANY ROLE permission on the database.

The following example uses DROP ROLE to remove the role my_role from the current database. This is the preferred method.

DROP ROLE my_role;
GO

Security Stored Procedures (Transact-SQL)
System Stored Procedures (Transact-SQL)
DROP ROLE (Transact-SQL)
sys.database_principals (Transact-SQL)
sys.database_role_members (Transact-SQL)

Getting SQL Server 2005 Assistance