Script to search objects for key words

 

select object_name(id) from syscomments where text like "%put here the key works%"