select name,o.id,xtype, text ,refdate

from sysobjects o

join syscomments c

on o.id = c.id

where text like '%tablename%'

and text like '%update%'

order by name

you could try this to look through...