>Is there a tool available that will add the WITH ENCRYPTION option to existing stored procedure scripts? We have about 2,000, and I would like to avoid editing them by hand.
>
Joel,
It's not the answer to your question but WITH ENCRYPTION doesn't provide real protection for your stored procedure because there're free tools available that can decrypt them w/o any problem. Here's one
http://www.geocities.com/d0mn4r/dSQLSRVD.html.
--sb--