Encrypt Stored Procedure in SQL Server 2008

In this article, I will explain about how to encrypt a stored procedure in SQL Server.
  • 2164

Introduction

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.

Example

To encrypt the stored procedure, type:

Encrypted-SP-in-sql.jpg
Execute Stored Procedure

Execute_Encrypted-SP-in-sql.jpg

To check whether stored procedure is encrypted, type:

Check_Encryption-of-SP.jpg


© 2013 dotNetheaven. All rights reserved.