Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
larus
Starting Member
17 Posts |
 Posted - 2010-06-10 : 05:42:41
|
| I have an AD group as a database user. When I try to drop this group from the database users, usingDROP 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? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-06-10 : 07:37:40
|
| If you added the individual users separately they'll have to be dropped one by one. |
 |
|
|
larus
Starting Member
17 Posts |
Posted - 2010-06-11 : 00:56:12
|
| I added them on ADUC, not in SQL Server. And when I drop this group in SQL Server, I get all these individual users visible in database users and I must drop them separately. That's odd. |
|
|
|
|
|
|
AD group as a user, how to drop all users at once?