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

Script Removal of Logins - SQL 2005 Expand / Collapse
Author
Message
Posted Friday, October 10, 2008 10:50 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 08, 2012 12:30 AM
Points: 150, Visits: 3,892

Does anyone have a script to remove logins for SQL 2005. I was hoping to find a script similar to this one (which has SQL 2000 syntax):

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30413/

I need the script to look for and revoke permission grants that prevent the dropping of the login similar to what the above script does for SQL 2000 logins.

Thanks!
Post #584133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse