Thursday, January 31, 2013

Encrypting the stored procedure in SQLServer


CREATE PROCEDURE [procName]
WITH ENCRYPTION
AS
BEGIN
SELECT  col1,col2,col3  from Table as 'userTableName'
END

Before encrypting kindly store the stored procedure original text file in your hard disk,because you wan't decode the procedure once encrypted.