Encrypt all

Hi to all
i have A LOT of stored procedures that i have to encrypt. There is any nice way to do it automatically without having to ALTER them with the ENCRYPTION keyword one by one?
Thanx in advanceI don't believe there is another way to do it. BOL makes it very clear the syntax required for altering a SP.

Good luck and I hope you have plenty of time on your hand.|||can i say "oh sh*t" ? :-)

i expected that anyway...just need to be sure of it

thanx|||I think you will be saying on S**t for every one you have to do manually!

Just remember to backup them up safely becaus once encrypted... you know the rest!

Good luck and have fun. Perhaps you could use this weekend to do it?! :)|||Every encrypted procedure can be decrypted, so if you just want to protect the code by doing that, don't waste your time. The code can be easily extracted even if is "encrypted".

Originally posted by Crespo-n00b
I think you will be saying on S**t for every one you have to do manually!

Just remember to backup them up safely becaus once encrypted... you know the rest!

Good luck and have fun. Perhaps you could use this weekend to do it?! :)|||mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

am i wrong? if yes can you show the proof?|||Well, take a look at
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngWId=5

Originally posted by manowar
mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

am i wrong? if yes can you show the proof?