Decrypt Stored Procedures, Views and Triggers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Joseph Gama » Decrypt Stored Procedures, Views and Triggers...

Decrypt Stored Procedures, Views and Triggers

Rate Topic

Display Mode

Topic Options

Author

Message

jgama

Posted Wednesday, October 03, 2007 10:57 AM

SSC 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

kodracon

Posted Sunday, August 30, 2009 12:11 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

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

sqlcentral2

Posted Wednesday, May 25, 2011 8:37 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:20 AM
Points: 96, Visits: 7,209

Used the stored procedure to decrypt another stored procedure of mine. It dropped it.

Caveat emptor.

4x4 photos

Post #1114770

MisplacedChildhood

Posted Wednesday, March 28, 2012 2:24 PM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 1:58 PM
Points: 743, Visits: 286

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 »

Permissions