查询某个表在那些SP中用到

SELECT A.name,B.definition
FROM sys.procedures A
JOIN sys.sql_modules B ON A.object_id = B.object_id
WHERE B.definition LIKE '%表名%'