Decryption of Encrypted Stored Procedures

Question

Post reply

Decryption of Encrypted Stored Procedures

Babou

SSC Enthusiast

Points: 137
More actions
March 23, 2004 at 9:41 pm

#84542

Hi,

Is there anyway to get the text in an encrypted stored procedures?

Viewing 10 posts - 1 through 9 (of 9 total)

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Yes, there are tools on the internet and some simple code at Planet-Source-Code to do this sorrt of thing. Note however some do it by changing the SP to garbage and comparing offsets so make sure you backup first and make sure you do not violate any license agreements you have, this should only be used strictly for recover of lost code for yourself or group.

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 2

Rodrigo Acosta

SSC-Insane

Points: 21261

March 24, 2004 at 6:20 am

#500203

But in most cases you must have sysadmin right to use such app. There are also stored procedures to decrypt encrypted procedures.

eswara Valued Member Points: 63 More actions · Answer 3

I found this from Planet Source Code. CHeck you adequate rights to use it.

CREATE PROCEDURE DECRYPTSP2K

@objName varchar(50)

AS

DECLARE @a nvarchar(4000), @b-2 nvarchar(4000), @C nvarchar(4000), @d nvarchar(4000), @i int, @t bigint

--get encrypted data

SET @a=(SELECT ctext FROM syscomments WHERE id = object_id(@objName))

SET @b-2='ALTER PROCEDURE '+ @objName +' WITH ENCRYPTION AS '+REPLICATE('-', 4000-62)

EXECUTE (@b)

--get encrypted bogus SP

SET @C=(SELECT ctext FROM syscomments WHERE id = object_id(@objName))

SET @b-2='CREATE PROCEDURE '+ @objName +' WITH ENCRYPTION AS '+REPLICATE('-', 4000-62)

--start counter

SET @i=1

--fill temporary variable

SET @d = replicate(N'A', (datalength(@a) / 2))

--loop

WHILE @i0

SET @d=REPLACE(UPPER(@d),'WITH ENCRYPTION', '')

--replace SP

execute( @d)

GO

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 4

Amit Jethva

SSCarpal Tunnel

Points: 4707

March 25, 2004 at 12:04 am

#500366

I use dSQLSRVD

http://www.geocities.com/d0mn4r/dSQLSRVD.html

-- Amit

"There is no 'patch' for stupidity."

Download the Updated SQL Server 2005 Books Online.

Babou SSC Enthusiast Points: 137 More actions · Answer 5

Babou

SSC Enthusiast

Points: 137

March 25, 2004 at 10:14 pm

#500578

Hi,

As said by Antares686 i found number of scripts and tools for decryption in planet-source-code site. Thanks for eswar for providing 'DECRYPTSP2K' it is working really fine.

I tried dSQLSRVD but it is giving some ADO Recordset error.

Thanks for your responses.