>For one of our clients we decided to install all the sprocs as encrypted until payment is made and also to protect some very critical sprocs from having someone "take a look" inside and mess something up (had it happen more than once from a client).
>
>The question I have been asked is this really secure ??? Could they (or anyone else) somehow un-encrypt the 179 sprocs (on SQL 2000) we have installed ???
>

I think so. Here's one of the free tools that does that at http://www.geocities.com/d0mn4r/dSQLSRVD.html.