You have to be very careful when encrypting stored procedures. You can't decrypt them. So if you want to look at them, you won't be able to, so you'll need to save off a copy of each of them.
i usually encrypt sprocs by including the with encryption option but I do this on QA where I can save the script. Like what Tara said, once encrypted, even the creator won't be able to view it.
Data Objects Encryption
Posted - 07/06/2004 : 11:56:58
