Does the LoginProperty(LOCKOUTTIME) value reset when a locked account is unlocked?

• jasona.work

  SSC Guru

  Points: 50082

  More actions

  August 20, 2013 at 2:22 pm

  #277173

  I found a script which generates a listing of SQL Logins and information culled from LoginProperty, including the LockoutTime value. What I'm curious to know is, does this value reset to 0 (well, OK, 1900-01-01 00:00:00.000) when a locked account is unlocked?

  Now, we currently use the trick of:

  alter login [{LoginName}] with check_policy = off;

  alter login [{LoginName}] with check_policy = on;

  to unlock an account, rather than fuss and fight with having to change the password, then change the password in any application which uses it...

  Lazy, I know.

  But my question still stands...

  Thanks,

  Jason

• jasona.work

  SSC Guru

  Points: 50082

  More actions

  August 20, 2013 at 2:25 pm

  #1643228

  Never mind, I just spotted a couple accounts with values in there, which are not locked. So I'm inclined towards it does keep the last value.