clean up accounts

• mtz676

  SSCrazy Eights

  Points: 9214

  More actions

  November 27, 2024 at 6:22 am

  #4489693

  EXEC sp_validatelogins <- Can we use this as a start to identify accounts in SQL as an initial step to start cleaning up accounts ?find accounts with these issues...collation mismatch & AD level login drop and recreate

  Or is there a more definitive way to do this ? where we can drop accounts in one go or should we have to check each account presence in AD based on the results of EXEC sp_validatelogins

  Thanks