Encrypting Stored procedures in sql server 2005
|
|
|
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
,My Sql, Asp.Net 2.0
|
Rank It |
|
