Locate Stored Procedures Related To a Table

—-Option 1

SELECT DISTINCT so.name

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE LOWER(sc.TEXT) LIKE ‘%name%’

—-Option 2

SELECT DISTINCT o.name, o.xtype

FROM syscomments sc

INNER JOIN sysobjects o ON sc.id=o.id

WHERE LOWER(sc.TEXT) LIKE ‘%name%’