WITH ENCRYPTION en masse

From: Simon Train (simon.train@btinternet.com)
Date: 09/25/02 

From: "Simon Train" <simon.train@btinternet.com>
Date: Wed, 25 Sep 2002 18:10:47 +0100

Has anyone come up with a reliable way of automatically inserting the WITH
OPTION to the text of stored procedures, views, user-defined functions or
triggers. I need to encrypt lots of objects en masse in production databases
and since some of the options already use WITH... options the insertion of
WITH OPTION is tricky.

Any ideas?

Thanks, Simon