In SQL 2005, there's a view called "sys.sql_modules", which has the definition (create script) for views, procs, etc. Books Online has the specifics.
Join that to sys.views to get the name (or to sys.all_objects) on object_id column.
If you can select from that, you should get what you need.
Edit: I just tested this with a proc with just over 75,000 characters, and it returned as a single row with the full text in it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon