Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

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

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 30, 2016 6:45 AM
Points: 67, Visits: 43
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: Tuesday, May 3, 2016 9:22 AM
Points: 326, Visits: 437
LOVE IT!!! Thanks for the funny!!!


Thank you!!,

Angelindiego

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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 4,131, Visits: 2,324
Nice
Post #1557178
Posted Tuesday, April 1, 2014 1:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:07 AM
Points: 2,900, Visits: 2,687
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: Tuesday, May 3, 2016 9:22 AM
Points: 326, Visits: 437
WHEW!! Thank goodness for the fix!!! YOU ROCK!!


Thank you!!,

Angelindiego

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

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,545, Visits: 17,211
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: Tuesday, May 3, 2016 9:22 AM
Points: 326, Visits: 437
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: Thursday, July 9, 2015 9:08 PM
Points: 2, Visits: 20
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: Monday, August 17, 2015 1:06 AM
Points: 5, Visits: 145
Love it (Shame on me!). Hans Loykens
Post #1557323
Posted Wednesday, April 2, 2014 6:01 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 9:54 AM
Points: 8,318, Visits: 16,471
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 ««1234»»»

Permissions Expand / Collapse