How to Encrypt the Stored Procedures in SQL 2005 Express

Dear All,

I am using SQL 2005 Express, and i need to Encrypt all my Stored Procedure while deploying in my Production Server.

Help me out to do.

Hi,

specify the procedure command with WITH ENCRYPTION and SQL Server will create the procedures encrypted.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de