Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Script out passwords Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 8:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:43 AM
Points: 13, Visits: 21
Thanks for the giggle this morning.
Post #1557034
Posted Tuesday, April 1, 2014 12:35 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 1:53 PM
Points: 320, Visits: 413
LOVE IT!!! Thanks for the funny!!!


Thank you!!,

Angelindiego

Post #1557161
Posted Tuesday, April 1, 2014 1:18 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 3,266, Visits: 1,959
Nice
Post #1557178
Posted Tuesday, April 1, 2014 1:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:34 AM
Points: 2,011, Visits: 2,013
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.
Post #1557181
Posted Tuesday, April 1, 2014 2:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 1:53 PM
Points: 320, Visits: 413
WHEW!! Thank goodness for the fix!!! YOU ROCK!!


Thank you!!,

Angelindiego

Post #1557216
Posted Tuesday, April 1, 2014 3:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:21 AM
Points: 1,345, Visits: 3,817
0x42657474657220746F2072656D61696E2073696C656E7420616E642062652074686F75676874206120666F6F6C207468616E20746F20737065616B206F757420616E642072656D6F766520616C6C20646F7562742E
Post #1557222
Posted Tuesday, April 1, 2014 3:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 1:53 PM
Points: 320, Visits: 413
AMEN!!!!!!


Thank you!!,

Angelindiego

Post #1557245
Posted Tuesday, April 1, 2014 7:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 6, 2014 9:52 AM
Points: 1, Visits: 8
We cannot really recover passwords from the server passwords from the server April Fools
Post #1557291
Posted Wednesday, April 2, 2014 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 3:51 AM
Points: 5, Visits: 123
Love it (Shame on me!). Hans Loykens
Post #1557323
Posted Wednesday, April 2, 2014 6:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 6,194, Visits: 13,350
lol convert this

0x646F6E2774206265206120646F726B20203A2D29



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1557419
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse