How can I unencrypted a stored procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » SQL Server Security Skills » How can I unencrypted a stored procedure

21 posts, Page 2 of 3

««1 2 3 »»

How can I unencrypted a stored procedure

Rate Topic

Display Mode

Topic Options

Author

Message

K. Brian Kelley

Posted Saturday, May 10, 2008 6:29 AM

Keeper of the Duck

Group: Moderators
Last Login: Wednesday, May 08, 2013 5:14 AM
Points: 6,583, Visits: 1,787

Profiler won't show you the CREATE PROCEDURE statement. You can get the execution of the procedure, but not the definition. If you try and run Profiler you'll get something akin to "-- Encrypted Text" for the TextData column.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog |

LinkedIn | Twitter

Post #498349

..:: Eric ::..

Posted Wednesday, January 18, 2012 8:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 18, 2012 9:18 PM
Points: 1, Visits: 4

Hello,

I am using SQL 2000 and I've same Problem here. and yes the script does work to solve the encrypted SP.
still there are some problem have not been solved. they are more than 4000 length SP script can't be decrypted.

i wonder if there are another solution for this kind of problem.

regards,
Eric

Post #1238429

johnycruen

Posted Wednesday, May 16, 2012 5:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 16, 2012 5:18 AM
Points: 1, Visits: 0

Hi,

Recently, I read one article about SQL Decryptor which explains the SQL Server encryption and decryption process. you can take help from it to get points clear about sql decryption for the encrypted database which included encryption of stored procedures, views, rules, etc.

http://www.articlesbase.com/software-articles/sql-decryptor-finest-solution-to-de-encrypt-sql-database-5902847.html

Post #1300917

jack.rider.rider

Posted Tuesday, June 05, 2012 11:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 9:08 AM
Points: 2, Visits: 1

No problem whatsoever if you want to decrypt stored procedures, tables or any other database in SQL server then you can just get the perfect solution from: http://tech.groups.yahoo.com/group/DecryptSQLServer2008/

Post #1311394

Russf

Posted Wednesday, June 06, 2012 1:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:44 AM
Points: 3, Visits: 954

Red Gate's SQL Compare will un-encrypt an "encrypted" stored procedure.

1) Start SQL Compare.

2) Specify the database , containing the encrypted procedure(s) , as both the source and target (can pick a different db if you wish as the target).

3) Click COMPARE.

4) In the results window, click on the stored procedure that you are interested in and BAZINGA..... there is the source code.

I was using version 8.1.0.360 in case your experience varies. I was using SQL 2005 . I tried on SQL 2000 and it also worked.

Post #1312140

simon.letts

Posted Tuesday, November 27, 2012 7:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:11 AM
Points: 122, Visits: 480

Just tried Redagte on a 2005 DB and it tells me its encrypted!!?

Post #1389187

Russf

Posted Tuesday, November 27, 2012 8:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:44 AM
Points: 3, Visits: 954

Under Options, ensure that "Decrypt Encrypted objects on 2005 and 2008 databases" is checked. Otherwise you will get "-- Text was encrypted" .

Post #1389218

simon.letts

Posted Tuesday, November 27, 2012 8:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:11 AM
Points: 122, Visits: 480

Thanks for your help with this, I'd love to get it working. However I dont see that 'option' Sad

Only an option to 'add with encryption' I have SQL Compare v6

Post #1389264

simon.letts

Posted Tuesday, November 27, 2012 9:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:11 AM
Points: 122, Visits: 480

Have downloaded v10 now so can see the option. Hoever it now only seems to compare tables and users, no other objects !?!?

Post #1389277

Russf

Posted Tuesday, November 27, 2012 2:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:44 AM
Points: 3, Visits: 954

I am using version 8.1 . There is a "Filter Setup" button that has a funnel icon. If you click this, it will show what is AND what is not included in the results pane. Make sure that "Stored Procedure" is checked. This might be why you do not see them.

Post #1389416

« Prev Topic | Next Topic »

21 posts, Page 2 of 3

««1 2 3 »»

Permissions