select distinct B.name as DB_Object from syscomments A inner join sys.objects B on A.id = B.object_id where A.text like '%your_table_name%';
Login to post response