Listing domain users not part of any user-defined databases

• karl1961

  Grasshopper

  Points: 12

  More actions

  November 10, 2004 at 3:16 pm

  #63557

  I need help in listing all domain users that no longer have access to any user-defined database. I have over 4000 logins so, a script to accomplish this task would help.

   

  Thank you

   

  Karl

  kgsmith@rehabcare.com

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  November 11, 2004 at 2:37 am

  #529741

  I believe what you're looking for is sp_helplogins

  Have a look in BOL for more info on this proc

  /Kenneth