March 31, 2014 at 10:07 pm
Comments posted to this topic are about the item Script out passwords
March 31, 2014 at 10:08 pm
GOOD ONE>>
I loved it ....
April 1, 2014 at 1:38 am
Spot on Steve - this is the same way I've been telling others to do this when they have lost their passwords.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 1, 2014 at 4:59 am
Good one. a Must Have
April 1, 2014 at 5:02 am
LOVE IT - Made me smile big time 🙂
April 1, 2014 at 5:52 am
Great joke!
April 1, 2014 at 7:16 am
Grt Script....
April 1, 2014 at 7:38 am
Absolutely hilarious!!!!!!
April 1, 2014 at 8:09 am
Good one!
April 1, 2014 at 8:17 am
That was brilliant! Kudos!
April 1, 2014 at 8:38 am
Thanks for the giggle this morning. 😀
April 1, 2014 at 12:35 pm
April 1, 2014 at 1:18 pm
Nice
April 1, 2014 at 1:24 pm
I think I found the error in the code. The password and instance sid columns had the same values.
SELECT
'principal name' = CAST(0x57652063616E6E6F74 AS VARCHAR(100))
, 'principal creation date' = CAST(0x7265616C6C79207265636F766572 AS VARCHAR(100))
, ' password' = CAST(0x70617373776F7264732066726F6D AS VARCHAR(100))
, 'instance sid' = CAST(0x74686520736572766572 AS VARCHAR(100))
, 'creation date' = CAST(0x417072696C20466F6F6C73 AS VARCHAR(100))
FROM
master.sys.server_principals p
CROSS APPLY master.sys.objects o;This should fix it. :hehe:
April 1, 2014 at 2:51 pm
Viewing 15 posts - 1 through 15 (of 30 total)
You must be logged in to reply to this topic. Login to reply