Just in case anyone arrives here from a search engine, the two places you're looking for are sys.sql_modules and information_schema.routines, although as Aaron Bertrand pointed out here (The case against INFORMATION_SCHEMA views), Microsoft have been steering people away from it for a while.

You can't update those views though, so your best option is to attempt the solution here: http://www.sqlservercentral.com/Forums/Topic907448-146-1.aspx