select o.name,o.type,definition
from sys.sql_modules m join sys.objects o on (o.object_id=m.object_id)
where definition like '%mmm%'