Post reply

Find Login Disabled Time in SQL Server

  • July 13, 2010 at 9:28 am

    #223771

    Hi,

    We can find the locked out time of a loing using the loginproperty('islocked') feature. Is there a way to find when a login has disabled?

    Thanks

  • July 13, 2010 at 9:43 am

    #1192180

    Did u check updatedate column in sys.syslogins table for ur login???

  • July 19, 2010 at 1:27 pm

    #1195101

    I checked that. But there is no guarantee it contains the disabled time. Is there any other way to check this?

  • July 19, 2010 at 1:30 pm

    #1195106

    Use LOGINPROPERTY('LockoutTime') instead.

    K. Brian Kelley
    @kbriankelley

  • July 21, 2011 at 1:59 am

    #1356180

    Hi

    This is not working as mentioned below please advice.

    SELECT LOGINPROPERTY('sa', 'IsLocked'); --Working

    SELECT LOGINPROPERTY('BRIDGESTONE-CU\activex29', 'IsLocked'); -- not Working

    Jayant Dass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply