SQL Server, ad group as a user: dropping many users at once
- by jrara
I have an AD group as a database user. When I try to drop this group from the database users, using
DROP USER [this_is_the_ad_group]
the group will be dropped but all the individual users in this group will not. How to delete this group and all its users at once?