How To Encrypt Stored Procedured In SQL SERVER 2005

Hi Sagar,
Inorder to encrypt the text of stored procedures containing sensitive information, Sql Server provides WITH ENCRYPTION to encrypt the Stored Procedure.

CREATE procedure [dbo].[SP_GET_Employee_Details_encrypt]
WITH ENCRYPTION AS

SELECT EMP_id,First_name,Last_name,Email_id
from Employee
Order by Email_id

Once the stored procedure has been created WITH ENCRYPTION, attempts to view the stored procedure returns a message specifying that the text is encrypted:

EXEC sp_helptext SP_GET_Employee_Details_encrypt

The text for object 'SP_GET_Employee_Details_encrypt' is encrypted.

One note of caution. Save the original text of the stored procedure before encrypting it, as there is no straightforward way to decode the encrypted text. One hack is to attach a debugger to the server process and retrieve the decrypted procedure from memory at runtime.
Refer this for more information
http://www.mssqltips.com/sqlservertip/1046/decrypting-sql-server-database-objects/

hi,

When you create SP @ that time use "With Encription" keyword.

CREATE PROCEDURE dbo.test
WITH ENCRYPTION
AS
BEGIN
    SELECT* from mydatatable
END

hope this help.

to decript sp please refer.

http://msdynamicstips.com/2008/12/24/decrypt-sql-2005-stored-procedures-functions-views-and-triggers/

Hi Sagar,


Please refer the below links

http://www.codeproject.com/Articles/38583/How-Do-I-Protect-My-Stored-Procedure-Code

http://www.codeproject.com/Tips/239100/Encrypting-all-the-Stored-Procedures-of-a-Database

Thanks