Link to home
Start Free TrialLog in
Avatar of KaranGupta
KaranGupta

asked on

Stored procedure with encryption in SQL server

Hi

If I create a stored procedure with encryption then I can not see the proc's definition either by using sp_helptext or by right clicking on the proc and generate the script.

Is there any way to generate the script for encrypted stored procedure?

If the answer is no, then while we give build for testing then we need to save the proc's definition in the hard disk and if that file is deleted from the hard disk there is no way to get the definition of proc (even if the deleted file is not recovered from any software).

So the encrypted procedure needs careful handling in terms of storage. Is my understanding correct?

Please advice.

Regards
Karan Gupta
ASKER CERTIFIED SOLUTION
Avatar of RehanYousaf
RehanYousaf
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial