tsql - Using sp_helptext on a encrypted store procedure -

yesterday created store procedure encryption exercise purposes forgot save query.

today planning view tsql code using

exec sp_helptext 'procedure_name' 

but since encrypted can't see code. wondering if there way solve this?

providing article in comment answer more folks may benefit

this article goes lot of details on how decrypt such objects..

it talks basic approach using code decrypt code system tables using 3rd party tools such dac , optillect (which seems not need admin privileges)

note: assuming using sql-server since have tagged tsql