,
Share this with your friends 
 

Encrypting Stored procedures in sql server 2005

0 ratings Views 550 
Author: johny (johny souriar)  View Profile |  View other solutions by this author

Question / Problem


How to encrypt stored procedures in sql server 2005

Solution

eg.

Create Procedure dbo.TestEnrypt
@EmpCd as char(8) With ENCRYPTION
As
SET NOCOUNT ON
Begin

Select EmpCd,EmpNm from EmployeeMaster where EmpCd=@EmpCd

End

// Note; After encrypt  source code  will not be accessible.

Applies to

Microsoft SQL Server 2005 ,MySQL, Asp.Net 2.0

Rank It

Login to rank it

Report


Advertisement