Hi,

If I need to encrypt existing SP in my database,is there any know command or function to do it all at once in script. I don't want to apply all my old SP with 'with encryption' command to my remote office. I know that to encrypt a SP, we need to append this command 'alter procedure xxxx with encryption' and might have to use sp_helptext to get all existing code. Anyone have done it or know of any tool that can do it, pls advise/thank.