Buscar String en Función, Procedimiento y Trigger SQL

select distinct o.type,object_name(c.id) 
from syscomments c
join sysobjects o on o.id=c.id
where c.ctext like '%TABLAUSUARIO%'
order by o.type,OBJECT_NAME(c.id)