decrypt sql server 2005 sp

Question

decrypt sql server 2005 sp

Mad-Dog

SSCertifiable

Points: 6117
More actions
May 21, 2008 at 11:06 am

#122165

hi,
how can i decrypt a stored procedure in sql server 2005?
THX

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

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

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

You need to be connected via the DAC. As to the exact means, I'd suggest you Google for it. No offense, but that's not something I'd post in a forum.

K. Brian Kelley
@kbriankelley

mobasha SSCertifiable Points: 5334 More actions · Answer 2

go there u will find a good one.

http://www.sqlfarms.com

..>>..

MobashA

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

avipenina (5/21/2008)
hi,
how can i decrypt a stored procedure in sql server 2005?
THX

I'm curious... where is your source code? Or are to trying to break in on someone else?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Mad-Dog SSCertifiable Points: 6117 More actions · Answer 4

Mad-Dog

SSCertifiable

Points: 6117

May 25, 2008 at 12:14 am

#820049

i lost my source code to a few encrypted SP

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

Ok... thanks...

Like the others have said, if you do a Google or other search, you'll find several articles on how to do this. It's just not something that most of us will post and I've not had to do it before.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mobasha SSCertifiable Points: 5334 More actions · Answer 6

never mind, there is even tools for it or u can use scripts.

i dont think it is that big deal!! as long as there is tools out thier u can just buy...

..>>..

MobashA

Mad-Dog SSCertifiable Points: 6117 More actions · Answer 7

the tools cost money.i try the script that i found in google but all they does is to delete the SP that i want to decrypt.

can you point me to article on how to do that?

THX

mobasha SSCertifiable Points: 5334 More actions · Answer 8

mobasha

SSCertifiable

Points: 5334

May 26, 2008 at 12:17 am

#820112

search more u cannot miss it.

..>>..

MobashA

Mad-Dog SSCertifiable Points: 6117 More actions · Answer 9

ok i found script that use the DAC connection to decrypt SP and it's works great.

THX

pokitlok SSC-Addicted Points: 471 More actions · Answer 10

pokitlok

SSC-Addicted

Points: 471

June 10, 2008 at 3:12 am

#826496

can you share the link / the source, please?!

Avishkar Meshram SSC-Addicted Points: 414 More actions · Answer 11

How about you script out all of the stored procedures into one file, then do a replace on:

AS

Change it to:

WITH ENCRYPTION

AS

Just use notepad or any other text editor to do it.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 12

This isn't something we typically post on the forums. However, there are tools readily available on the Internet if you do a search using Google.

K. Brian Kelley
@kbriankelley

PAULO.FONSECA Newbie Points: 3 More actions · Answer 13

Hi, i buy a software called sql decryptor searching in the cnet.com web site by US$ 9.95 and resolve my problem.

😉

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 14

Mad-Dog (5/26/2008)
ok i found script that use the DAC connection to decrypt SP and it's works great.
THX

Heh... two way street here, MD... share your solution. Where did you find the script? Cough up a link, please.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)