Script out passwords

Question

Script out passwords

Viewing 15 posts - 16 through 30 (of 30 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 1

0x42657474657220746F2072656D61696E2073696C656E7420616E642062652074686F75676874206120666F6F6C207468616E20746F20737065616B206F757420616E642072656D6F766520616C6C20646F7562742E

😎

Angelindiego SSCertifiable Points: 6048 More actions · Answer 2

Angelindiego

SSCertifiable

Points: 6048

April 1, 2014 at 3:34 pm

#1702260

AMEN!!!!!! 😛

Thank you!!,

Angelindiego

tuzhen007 58438 Grasshopper Points: 20 More actions · Answer 3

We cannotreally recoverpasswords from the serverpasswords from the serverApril Fools

😀

Hans Loykens Newbie Points: 9 More actions · Answer 4

Hans Loykens

Newbie

Points: 9

April 2, 2014 at 12:11 am

#1702328

Love it (Shame on me!). Hans Loykens

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

lol convert this

0x646F6E2774206265206120646F726B20203A2D29

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

"Ya can't make an omelette without breaking just a few eggs" 😉

Angelindiego SSCertifiable Points: 6048 More actions · Answer 6

Keep 'em comin' boyz!!! Too fun....dork dork!!

Thank you!!,

Angelindiego

webrunner SSC-Dedicated Points: 31882 More actions · Answer 7

Ha ha ha. Nice.

I was scared for a moment that this was a real script, until I checked the comments.

Thanks,

webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

thood1 SSC Enthusiast Points: 118 More actions · Answer 8

thood1

SSC Enthusiast

Points: 118

April 3, 2014 at 9:41 am

#1702925

Pretty slick!!!

ilshat78 Newbie Points: 7 More actions · Answer 9

ilshat78

Newbie

Points: 7

October 9, 2015 at 1:11 am

#1832450

Must Have!!!

jake.carter Grasshopper Points: 15 More actions · Answer 10

jake.carter

Grasshopper

Points: 15

October 9, 2015 at 6:29 am

#1832507

That was class!!

Brian J. Parker SSC Eights! Points: 880 More actions · Answer 11

Well played!

Although it might be worth mentioning here that you can script out login creation statements (with SID and password hash) to move logins from one server to another, which will work with databases restored from the same server. That's kind of what I thought this might be, when I first read the title. Microsoft offers this (https://support.microsoft.com/en-us/kb/246133) but their script can definitely be improved upon... although I don't think I've seen a good one posted anywhere? (I've seen a nice Powershell version, but not T-SQL.) Would there be any interest in that sort of thing?

Michael L John One Orange Chip Points: 27060 More actions · Answer 12

You have wayyyyy too much time on your hands Steve.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 13

Michael L John (10/9/2015)
You have wayyyyy too much time on your hands Steve.

That is certainly not true.

Eric M Russell SSC Guru Points: 125562 More actions · Answer 14

You can do a brute force dictionary query against the sys.sql_logins table.

http://www.sqlservercentral.com/Forums/FindPost1623412.aspx

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 15

akljfhnlaflkj

SSC Guru

Points: 76202

October 21, 2015 at 7:44 am

#1834670

Funny. I actually thought you had something there.