Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

How can I unencrypted a stored procedure Expand / Collapse
Author
Message
Posted Saturday, May 10, 2008 6:29 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, July 10, 2014 1:34 PM
Points: 6,623, Visits: 1,855
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
Posted Wednesday, January 18, 2012 8:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, May 16, 2012 5:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 5, 2012 11:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 3, 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
Posted Wednesday, June 6, 2012 1:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:29 PM
Points: 3, Visits: 1,101
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
Posted Tuesday, November 27, 2012 7:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 27, 2014 3:23 AM
Points: 141, Visits: 522
Just tried Redagte on a 2005 DB and it tells me its encrypted!!?
Post #1389187
Posted Tuesday, November 27, 2012 8:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:29 PM
Points: 3, Visits: 1,101
Under Options, ensure that "Decrypt Encrypted objects on 2005 and 2008 databases" is checked. Otherwise you will get "-- Text was encrypted" .


Post #1389218
Posted Tuesday, November 27, 2012 8:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 27, 2014 3:23 AM
Points: 141, Visits: 522
Thanks for your help with this, I'd love to get it working. However I dont see that 'option' Only an option to 'add with encryption' I have SQL Compare v6
Post #1389264
Posted Tuesday, November 27, 2012 9:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 27, 2014 3:23 AM
Points: 141, Visits: 522
Have downloaded v10 now so can see the option. Hoever it now only seems to compare tables and users, no other objects !?!?
Post #1389277
Posted Tuesday, November 27, 2012 2:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:29 PM
Points: 3, Visits: 1,101
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse