ENCRYPTION .......Procedure

Question

CREATE PROCEDURE spEmp
WITH ENCRYPTION
AS
BEGIN
    SELECT 'EmpNameKen'
END

 

sp_helptext spEmp

The text for object 'spEmp' is encrypted

My issue is how can we view(retrive) procedure text for alter purpose


thanx in advance

saju

Answer 1

Apparently, whoever wrote the code didn't want others to read the code.I suggest that you contact the developer / vendor who supplied the stored procedure code and request them a copy of the code.

 

 

---

Thanks, Leks

Answer 2

Apparently, whoever wrote the code didn't want others to read the code.I suggest that you contact the developer / vendor who supplied the stored procedure code and request them a copy of the code.

 

 

Answer 3

When you specify the WITH ENCRYPTION option, it is not possible to get the text of that procedure back through any normal means. As Lekss said, you will have to ask whoever wrote it or the company that provided it for the actual code.