Execute the following query by replacing the "update tablename" search term with your own:

SELECT Name, left(Text,1024)
FROM sysobjects JOIN syscomments
ON sysobjects.id = syscomments.id
WHERE Type = 'P'
and Text like '%update tablename%'