A good overview of the INFORMATION_SCHEMA views, Tom, and I, like Eric, also use them where possible. For the situation you mentioned with the routine definition spanning two rows, you can use the sys.sql_modules view, since the whole definition fits on one row.

John