Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Drop All Users in the Database Expand / Collapse
Author
Message
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: Yesterday @ 4:00 AM
Points: 3, Visits: 329
Hello,


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

http://sqlscripts.sql-assistance.com


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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, October 11, 2014 12:31 AM
Points: 115, Visits: 239
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.


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

Add to briefcase ««12

Permissions Expand / Collapse