May 25, 2011 at 10:00 pm
Comments posted to this topic are about the item Bad Passwords
May 25, 2011 at 11:50 pm
Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:
May 26, 2011 at 12:06 am
ma-516002 (5/25/2011)
Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:
That is true, but you get also the result from the query, and that is the same as the first answer. So it is just the introduction that has a typo 😀
Oh wait, not just the introduction: fix minutes 😀 Steve, were you doubting between five and six? 😛
Anyway, great question, definately learned something.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 26, 2011 at 12:26 am
Koen Verbeeck (5/26/2011)
ma-516002 (5/25/2011)
Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:That is true, but you get also the result from the query, and that is the same as the first answer. So it is just the introduction that has a typo 😀
Oh wait, not just the introduction: fix minutes 😀 Steve, were you doubting between five and six? 😛
Anyway, great question, definately learned something.
Some typos, but a great question. I had to think because of the typos. 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
May 26, 2011 at 1:47 am
ma-516002 (5/25/2011)
Actually none of the proposed answers is correct, since the question states "...and at 10:00am on 2011/05/01...". None of the answers has the year 2011 in them...:w00t:
If the original result, as per question, is
2010/05/01 10:00am
then the answer given is correct.
May 26, 2011 at 1:50 am
In sql2005, I tried with other logins than sa and I get always the following:
1900-01-01 02:00:00.000
Step 1: bad password attempt
Step 2: correct login
I run the query: SELECT loginproperty('carlo', 'badpasswordtime')
The result: 1900-01-01 02:00:00.000
Note the hour 2
?????
May 26, 2011 at 2:01 am
-- to see all bad attempts
SELECT l.name, loginproperty(l.name, 'BadPasswordTime')
FROM sys.syslogins l
May 26, 2011 at 2:17 am
Steve,
Thanks for that question, I'd was not aware of 'loginproperty' until now.
One question though. I tried to recreate your scenario but always get '1900-01-01 01:00:00.000' as the result. Anyone have any ideas why?
May 26, 2011 at 2:37 am
Thank you Steve, good question.
M&M
May 26, 2011 at 2:54 am
This was removed by the editor as SPAM
May 26, 2011 at 3:33 am
stewartc-708166 (5/26/2011)
Have there ever been bad login attempts to that instance?
Yes, I attempted to create one (as in Steve's scenario) by logging in via SSMS using an invalid password for sa.
May 26, 2011 at 4:28 am
How long is fix minutes?
John
May 26, 2011 at 4:40 am
john barnett (5/26/2011)
How long is fix minutes?John
"It depends", in SQL server 2000 it's the millisecond before six, but in later versions it's the microsecond before six. 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
May 26, 2011 at 5:02 am
hakan.winther (5/26/2011)
john barnett (5/26/2011)
How long is fix minutes?John
"It depends", in SQL server 2000 it's the millisecond before six, but in later versions it's the microsecond before six. 🙂
No, its a new roman-hexadecimal fusion numbering system.
Where hex F = 15 and Roman IX = 9 Therefore FIX = 24 🙂
May 26, 2011 at 5:13 am
nigel. (5/26/2011)
Steve,Thanks for that question, I'd was not aware of 'loginproperty' until now.
One question though. I tried to recreate your scenario but always get '1900-01-01 01:00:00.000' as the result. Anyone have any ideas why?
Maybe you are not running on Windows Server 2003 (or 2008?), or don't have both CHECK_POLICY and CHECK_EXPIRATION enabled?
Tom
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply