Login Properties

  • Yay, I got this question right! (I know, I know, 50-50 chance....)

    I do have one follow-up question. One of our dev servers returned 1900-01-01 00:00:00.000 when I ran SELECT loginproperty('sa', 'badpasswordtime').

    Does that datetime mean that there has not yet been a time on that server when sa was unable to connect because of a bad password? Just checking.

    Thanks,

    webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Good question and I got it right

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

Viewing 2 posts - 16 through 16 (of 16 total)

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