This article shows a SQL Script that will decrypt stored procedures in SQL. I've only test this in SQL 2000 but the author (noted in the script) claims that it will work on 2005 and 2008 also.