Decrypting Stored Procedures - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Decrypting Stored Procedures

Author

Topic

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:22:42

Hi.. I have encrypted a stored procedure using "WITH ENCRYPTION" keyword in sql server 2000. Now i need to Decrypt that.. How to do??

Sundaresan.R

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 08:28:38

Use Google to find out.
There are many examples how to re-obfuscate stored procedures in SQL Server.

E 12°55'05.25"
N 56°04'39.16"

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:36:00

I browsed through.. But didnt get stored procedures decrypt. Please help me in this regard..

Sundaresan.R

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:39:55

I tried this decrypting stored procedure.. But its not working..

<stored procedure removed by spirit1 because it violates site policy>

Sundaresan.R

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 08:40:20

Strange... I typed

+"with encryption" +reverse +sql

in the Google search text field and got hundreds of result!

E 12°55'05.25"
N 56°04'39.16"

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:46:31

Im getting the following error while trying to decrypt the SP using sp_decrypt_sp

Server: Msg 512, Level 16, State 1, Procedure sp_decrypt_sp, Line 7.
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
an expression.

Sundaresan.R

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-03 : 08:48:42

Use TOP 1.

E 12°55'05.25"
N 56°04'39.16"

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:51:53

If i use TOP 1 only part of the stored proc is decrypted. So the stored Proc is getting dropped

Sundaresan.R

Kristen
Test

22859 Posts

Posted - 2007-10-03 : 08:55:06

Assuming that you have actually accidentally encrypted an SProc, then restore from backup to prior to the accident (restore to a NEW, TEMPORARY database), and retrieve the code from there.

Kristen

Sundaresan
Starting Member

28 Posts

Posted - 2007-10-03 : 08:56:08

when SET @OrigSpText1=(SELECT ctext FROM syscomments WHERE id = object_id(@objectName) )
is executed im getting the error because the encrypted SP is stored as two rows in syscomments table. So, there will be two rows of ctext. Assigning two rows to a single variable results in error. I need to decrypt both the rows to get the original SP

Sundaresan.R

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-10-03 : 09:07:03

In case you haven't noticed, this forum is not for posting questions, but only for posting working sql scripts.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2007-10-03 : 09:23:42

quote:
Originally posted by Sundaresan

Hi.. I have encrypted a stored procedure using "WITH ENCRYPTION" keyword in sql server 2000. Now i need to Decrypt that.. How to do??

Sundaresan.R

Check the source out of source control and go from there.
If you don't own the source, you are in the wrong place if you want it cracked

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources