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%'