Hi Ken,

Great scripts!

Do you have anything that works with Windows Users\Logins?

I wrote a script awhile ago that removes database access for each user and reassigns it.

It's a pain if the user owns any objects as it has to swap ownership during the process,

but it works. It also takes into account permissions.

Your script is much more simple. The only problem is with Windows Users\Logins.

Any ideas?

Thanks!