text: /*
  Author: Perry Whittle
  Original link: http://sqlstudies.com/2013/03/01/script-to-clean-up-windows-logins-no-longer-in-ad/
  */
  
  IF (OBJECT_ID(‘tempdb..#invalidlogins’) IS NOT NULL)
  BEGIN
  DROP TABLE #invalidlogins;
  END
  
  CREATE TABLE #invalidlogins(
    perr ACCTSID VARBINARY(85)
  , NTLOGIN SYSNAME);
  
  INSERT INTO #invalidlogins
  EXEC sys.sp_validatelogins;
  
  SELECT NTLOGIN FROM #invalidlogins
  ORDER BY 1;
  