Cacher is the code snippet organizer for pro developers

sp_helptext mdAdvertGetByAdvertID

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%xxxxxxx%' 
AND ROUTINE_TYPE='PROCEDURE'