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 Wednesday, September 5, 2007 10:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 7, 2007 9:52 AM
Points: 11, Visits: 1
I got few stored procedures With Encryption for the database that I converted to SQL Server 2000.   I need to access those stored procedures.   How can I un-encrypted them?
Post #396563
Posted Thursday, September 6, 2007 10:44 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, May 8, 2014 1:21 PM
Points: 1,487, Visits: 510
Try this:
http://www.mssqltips.com/tip.asp?tip=1046



Post #397003
Posted Saturday, November 17, 2007 9:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:52 AM
Points: 1,326, Visits: 1,288
Hi,
You can also check theses links
http://www.sqlmag.com/Article/ArticleID/95728/sql_server_95728.html
http://khsw.blogspot.com/2004/08/decrypt-stored-procedures-on-sql.html
http://www.sql-shield.com/decrypt-stored-procedure.html
http://www.sqlmag.com/Article/ArticleID/14369/How_can_I_decrypt_a_SQL_Server_storedprocedure.html
Regards,
Ahmed


Post #423367
Posted Sunday, November 18, 2007 5:58 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
If it's SQL Server 2000, there's no better tool than:

dSQLSRVD - dOMNAR's SQL Server SysComments Decryptor

It doesn't work on SQL Server 2005, which requires an admin connection, etc., but it's great for SQL Server 2000.


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 #423373
Posted Monday, November 26, 2007 6:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 28, 2012 4:39 AM
Points: 49, Visits: 70
IF I am not mistaken I thought the unencrypted version is stored in one of the sys tables. Unfortunately I can't remeber which one.
Post #425709
Posted Monday, November 26, 2007 11:31 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
Ron Aughenbaugh (11/26/2007)
IF I am not mistaken I thought the unencrypted version is stored in one of the sys tables. Unfortunately I can't remeber which one.


Unfortunately, no. In syscomments it is encrypted. I believe in SQL Server 2005 it's encrypted as well. SQL Server 2005 makes it more difficult because you've got to come in via DAC to be able to decrypt.


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 #425925
Posted Wednesday, April 16, 2008 4:59 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 186, Visits: 815
Hello,

Thanks a lot Brian, the tool that you told me (dOMNAR's SQL Server SysComments Decryptor) was very usefull.

Thanks and regards,
JMSM ;)
Post #485547
Posted Monday, April 21, 2008 1:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 6, 2014 6:13 PM
Points: 318, Visits: 1,183
You can get "SQL Server 2005 Code Recovery" from here that does the 2005 DAC decrypt for you in a no-brain manner if you don't mind paying a little.

Regards,

Jacob

Post #487748
Posted Friday, May 9, 2008 3:59 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 19, 2012 9:22 AM
Points: 52, Visits: 381
Try this,

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5


- Zahran -
Post #498257
Posted Friday, May 9, 2008 6:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 7,135, Visits: 15,148
Have you tried turning on profiler and running the procedure?

Often enough - Profiler will capture the unencrypted version of the procedure. No fuss, no muss.


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #498298
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse