Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2013-06-05 : 11:48:32
|
| I have a stored procedure that I encrypted (with encryption).I need to know if there is a command to decrypt my procedure in case I lost the source code |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-06-05 : 12:03:09
|
| My understanding is that, once the text of a SP is encrypted (created with the WITH ENCRYPTION keyword), it is not possible to get original text of the SP from SP itself. Any one who created SP will need to save the text to be used to create SP somewhere safe to reuse it again.CheersMIK |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-05 : 13:38:52
|
| MIK, although I have not had an opportunity to try it, I think you can recover the clear text by connecting using DAC. http://msdn.microsoft.com/en-us/library/ms178068(v=sql.105).aspx |
|
|
|
|
|
|
decrypt storage procedure