you don't need to join to sysobjects to get the name:

select object_name(id) from syscomments

where text like '%[text]%'

'Nuff Said..