Modify SQL Server 2005 T-SQL Database scripts to encrypt/protect storedSQL box procedures.

This was a tiny bit of code i used to help with quickly encrypting stored procedures in a SQL Server 2005 database script. Hopefully it'll save you some time as it did me...... It uses the extremely helpful Regex search and replace in .NET




Original SQL script
 Protected script
xxxx stored procedures found!

Restrictions:

  • The tool currently only encrypts stored procedures.
  • There seems to be issues with procedures containing .net code. (Just remove the 'protected' comments from these.