SELECT DISTINCT objects.name, objects.type,
comments.text proc_defintion
FROM syscomments comments
INNER JOIN sys.objects objects
ON comments.id=objects.object_id
WHERE comments.text LIKE ‘%tbl_Batch_Recipe_Ingredient_Record%’
AND objects.type=’P’
multiple references,