How to identify all stored procedures referring a particular table

  1. SELECT Name   
  2. FROM sys.procedures   
  3. WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'