Query to find any text in stored procedures

SELECT DISTINCT tSO.Name,tSO.Type_Desc FROM sys.sysComments tSC
JOIN sys.objects tSO ON tSO.Object_Id = tSC.Id
WHERE tSC.Text LIKE '%dbo.conferencemedia%'