Coffeehouse Post

Single Post Permalink

View Thread: How big are your sprocs?
  • User profile image

    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).