Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does the LoginProperty(LOCKOUTTIME) value reset when a locked account is unlocked? Expand / Collapse
Author
Message
Posted Tuesday, August 20, 2013 2:22 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 730, Visits: 5,323
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
Post #1486431
Posted Tuesday, August 20, 2013 2:25 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 12:28 PM
Points: 730, Visits: 5,323
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.
Post #1486433
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse