I worked on a sql server 6.5 database for a large charity donation system which had 1500 sprocs with the avergage line count being about 500 lines, some were in excess of a 1000 lines long.

And I had to go through and convert these old procs to be sql server 2000 compliant (no compatibility mode).

Sad