SysComments is a system table that holds all the scripts of all the objects of the database (sps, triggers, views...).  So this technic is really fast an effective to find out stuff like that.