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

Logins Expand / Collapse
Author
Message
Posted Friday, May 16, 2008 12:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 10:10 AM
Points: 16, Visits: 161
Hi ,
Is there any script to delete all the logins that don't have any mappings with the database?
Post #502297
Posted Friday, May 16, 2008 1:26 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:23 AM
Points: 318, Visits: 351
There's not specifically a builtin script for it, but feel free to write it yourself. It doesn't sound like it should be that difficult. Just off the top of my head I'm thinking it'll involve a couple cursors through the user DBs. But that's without looking into it at all.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #502324
Posted Friday, May 23, 2008 9:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 10:10 AM
Points: 16, Visits: 161
can you give me some hints in writing the code?
Post #505943
Posted Saturday, May 24, 2008 3:40 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Sunday, January 29, 2012 1:45 AM
Points: 710, Visits: 1,284
there are some procedure u can use thier output:
1- sp_helplogin
2- sp_change_users_login


..>>..

MobashA
Post #506278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse