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

Decrypt Stored Procedures, Views and Triggers Expand / Collapse
Author
Message
Posted Wednesday, October 3, 2007 10:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 30, 2006 8:57 PM
Points: 31, Visits: 1
Comments posted to this topic are about the item Decrypt Stored Procedures, Views and Triggers


Post #406320
Posted Sunday, August 30, 2009 12:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:57 AM
Points: 55, Visits: 159
Hi All

here is my version of a script that ENCRYPTS all stored procedures:
http://www.sqlservercentral.com/scripts/WITH+ENCRYPTION/65041/

Enjoy!
Post #779534
Posted Wednesday, May 25, 2011 8:37 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 10:13 AM
Points: 122, Visits: 9,002
Used the stored procedure to decrypt another stored procedure of mine. It dropped it.

Caveat emptor.


4x4 photos
Post #1114770
Posted Wednesday, March 28, 2012 2:24 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 2:11 PM
Points: 743, Visits: 290
It also dropped my test stored procedure. It also gave me errors stating that thjere were more than one row returned for SET @a=(SELECT ctext FROM syscomments WHERE id = object_id('proc_LETTER_SERIES')). It also did not put quotes around the stored procedure, so I manually tried to run the steps after correcting the syntax. That's when it dropped the original and never created the decrypted procedure.
Post #1274660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse