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