Logins

• swekik

  SSC-Addicted

  Points: 486

  More actions

  May 16, 2008 at 12:52 pm

  #182569

  Hi ,

  Is there any script to delete all the logins that don't have any mappings with the database?

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  May 16, 2008 at 1:26 pm

  #816704

  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.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE:
  
  

• swekik

  SSC-Addicted

  Points: 486

  More actions

  May 23, 2008 at 9:02 am

  #819752

  can you give me some hints in writing the code?

• mobasha

  SSCertifiable

  Points: 5334

  More actions

  May 24, 2008 at 3:40 pm

  #820021

  there are some procedure u can use thier output:

  1- sp_helplogin

  2- sp_change_users_login

  ..>>..

  MobashA