November 8, 2008 at 11:24 am
Comments posted to this topic are about the item Changing Passwords
November 8, 2008 at 12:03 pm
Heh. You know all of those answers looked OK to me. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 8, 2008 at 2:32 pm
While I'm sure you'd enjoy going home, you should change the password. Finding a DBA or even moving to another workstation is fairly inefficient.
November 10, 2008 at 4:20 am
An amusing set of options. Would be a useful interview first question. Would you even consider one that chooses last answer?
November 10, 2008 at 5:01 am
The -Z parameter might work fine if you are an administrator or have rights to change passwords on the SQL Server instance, otherwise I don't think it will help much. Since the question seemed to assume that you were not a dba, I assumed the -Z parameter would be useless as well.
November 10, 2008 at 5:08 am
tom.gilmore (11/10/2008)
The -Z parameter might work fine if you are an administrator or have rights to change passwords on the SQL Server instance, otherwise I don't think it will help much. Since the question seemed to assume that you were not a dba, I assumed the -Z parameter would be useless as well.
You can (almost) always change your own password!
SQLCMD -U MyLogin -P 0LDP455W0RD -Z N3WP455W0RD
Derek
November 10, 2008 at 7:18 am
Sorry, I didn't read the question quite completely. I missed the part about it having expired. I based my comment on the password just not working.
November 10, 2008 at 11:09 am
The option I MUST use in my shop is not listed. We are to call the help desk for any issues relating to passwords no matter where they reside.
Inefficient, yes, but I also stay employed. 😉
November 10, 2008 at 12:13 pm
You cannot reset your password, but you can change it on expiration.
Not sure I'd hire anyone who chose the last option as anything other than a joke. Not sure I'd want to keep anyone that did it for real.
November 10, 2008 at 5:54 pm
even though I went with the Z param but I must agree that if you are not a dba that would not help anyway 😉
Cheers,
John Esraelo
November 11, 2008 at 1:56 am
John Esraelo (11/10/2008)
even though I went with the Z param but I must agree that if you are not a dba that would not help anyway 😉
Why not help? They have they 4th option for them and I found 1% answered that option. Steve it was a brilliant option... 🙂
November 11, 2008 at 5:26 am
I love the last answer - just go home. That one is the winner. :w00t: Gotta love it when someone has a sense of humor. Great question Steve!
Jamie
December 24, 2010 at 7:16 pm
I loved the answer to go home.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply