Articles → SQL SERVER → Stored procedure encryption in SQL server

Stored procedure encryption in SQL server


















Software requirement





Prerequisite knowledge





What does encryption means?





Syntax




CREATE PROC <PROC_NAME>
[LIST OF INPUT VARIABLES]
WITH ENCRYPTION
AS
<PROC_BODY>



Example




CREATE PROC sp_GetDBName
@db_name varchar(100)
WITH ENCRYPTION
AS
SELECT * FROM SYS.databases Where name = @db_name





Click to Enlarge




Click to Enlarge


Disadvantage of encrypting a stored procedure





Posted By  -  Karan Gupta
 
Posted On  -  Saturday, February 02, 2013

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250