Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Drop All Users in the Database Expand / Collapse
Posted Sunday, June 30, 2013 4:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 3, 2014 4:40 AM
Points: 3, Visits: 331

You can find here an interesting script that works with all versions of sql server (2000, 2005, 2008, 2012):

It can be used to delete all users in a database, all users in a database except a list of users or it deletes just a list of users (the others remain untouched).

I hope it helps :)
Post #1468853
Posted Tuesday, July 2, 2013 7:49 AM


Group: General Forum Members
Last Login: Friday, July 22, 2016 8:08 AM
Points: 123, Visits: 270
Hi Everyone
I got a request to delete all the logins except service accounts. So is there any script for working on this?
I tried above one but there is no luck

Advance thanks for your help.

I’m nobody but still I’m somebody to someone………….
Post #1469511
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse