If it's SQL Server 2000, there's no better tool than:
dSQLSRVD - dOMNAR's SQL Server SysComments Decryptor
It doesn't work on SQL Server 2005, which requires an admin connection, etc., but it's great for SQL Server 2000.
K. Brian Kelley
@kbriankelley