Encrypting stored procedures and functions

To encrypt sprocs and functions prior to deployment include the WITH ENCRYPTION option:

E.g. CREATE PROCEDURE [dbo].[USP_TEST_ENCRYPTION]…

WITH ENCRYPTION

Any encrypted sprocs will then have the lock symbol next to them. Functions will appear the same but you

will get an error message box if you try to access the code.