I have used screen scraper http://www.velocityscape.com for this sort of problem int the past. It's fairly straight forward to use - you define a template, and your output...

thanks,

but this returns the create view ... as well as the sql, same as sp_helptext. I really wanted just to

return the body sql of the view