Finding Table or Column usage in Objects (Table, Views, Functions, Procedures)

select * from sys.objects where object_id in (select id from syscomments where text like '%merge%')

It will find Merge word from all system objects.