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