Query to find a particular text in stored procedures on a database

-- Query to find a particular text in stored procedures on a database

select s.namefrom sysobjects s inner join syscomments c on s.id = c.idwhere c.text like '%table name%'