Sergey,

Thanks for the info, honestly I can't see any self-respecting DBA that would allow encrypted SPs to be on their databases given the extreme risk to the database integrity that could be maliciously hidden in there.

>The WITH ENCRYPTION doesn't provide real protection for the stored procedure because there're free tools available that can decrypt them w/o any problem. Here's one them at http://www.geocities.com/d0mn4r/dSQLSRVD.html. You can find more of them on the Internet.