script to validate users

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  May 1, 2008 at 10:47 am

  #72026

  ANyone seen a script to validate nt/sql users. In our 3rd party app the individual user is added as a login. But during time these people may leave. Trying to validate the users who no longer are valid (we do use AD)

• the__t

  Hall of Fame

  Points: 3260

  More actions

  May 1, 2008 at 12:10 pm

  #809755

  USE master

  EXEC sp_validatelogins

  GO

  "Got no time for the jibba jabba!"
  -B.A. Baracus