Blank password

• New2SQL-404798

  SSC Enthusiast

  Points: 171

  More actions

  July 3, 2008 at 1:11 pm

  #190056

  Does any one have a script to pull SQL logins with blank password?

• MannySingh

  SSChampion

  Points: 12465

  More actions

  July 3, 2008 at 1:24 pm

  #838098

  select * from master..syslogins

  where password is NULL

  and to Filter out NT ID's

  select * from master..syslogins

  where password is NULL

  and isNTName <>1

  Maninder
  www.dbanation.com