Database logins

• devereauxj

  Hall of Fame

  Points: 3263

  More actions

  January 26, 2004 at 10:31 am

  #152024

  I need to pull the logins from 20 instances of SQL Server 2000.  What table(s) are the logins contained?

   

  Thanks,

  Joseph

• Garutyunyan

  SSCrazy

  Points: 2629

  More actions

  January 26, 2004 at 11:25 pm

  #491703

  All logins are in the syslogins system table in the master database. Make sure you get the SID's as well.

• Ken Klaft-80806

  Say Hey Kid

  Points: 693

  More actions

  January 27, 2004 at 6:04 am

  #491739

  Google for sp_help_revlogins