Stored Procedures Related to Table in Database

--Description: This query is used to find all stored procedure which are used in a specific table in database using sql server
SELECT
DISTINCT sp.name as StoredProcedureName
FROM
syscomments scomment
INNER
JOIN sysobjects sp ON scomment.id=sp.id
WHERE
scomment.TEXT LIKE '%BannerStatistics%'