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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy