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