Login Properties

• webrunner

  SSC-Dedicated

  Points: 31059

  More actions

  May 5, 2011 at 7:24 am

  #1320365

  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

• BuntyBoy

  SSCommitted

  Points: 1876

  More actions

  September 1, 2011 at 8:31 pm

  #1376246

  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]