Encrypt Stored Procedure in SQL Server 2008
In this article, I will explain about how to encrypt a stored procedure in SQL Server.
Sometimes we need to hide our business logic from end users due to security purpose. So WITH ENCRYPTION is used to encrypt the schema of the stored procedure. After stored procedure get encrypted, it is not possible to get original text from the stored procedure.
To encrypt the stored procedure, type:
Execute Stored Procedure
To check whether stored procedure is encrypted, type: