查询哪些存储过程使用了某个表

SELECT DISTINCT
	b.name,
	b.type
FROM	dbo.syscomments a,
		dbo.sysobjects b
WHERE a.id = b.id
AND b.xtype = 'p'
AND a.text LIKE '%officedba.CodeProductType%'
ORDER BY name

查出的结果  p指的是存储过程

excelIntoSql	                                      P 
excelIntoSql_beifen	                               P 
GetProductNextCD	                              P 
GetSellOrderProductType	                              P 
SP_GetBomDetail_ByProjectForProcess	              P 
sp_GetBomListfb	                                      P 
sp_GetBomListfbAL	                              P