GarethPhilpott
So the crux of my post:
What SQL should I be running to make it spit out the procs?
Try this ... tested using SSMS -- with query output as text in new tab.
Select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION
From INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE'
AND ROUTINE_DEFINITION LIKE '%update%'