An interesting question, no doubt. I
blogged about this a while back as I created a simple Windows Forms application that inspects your database and enables searching the contents of stored procedures as well as summuary data for all your stored procedures.
- 63 stored procedures
- 2,100 lines of code
- 33 lines of code on average
It's not super smart in that it counts white space as I believe I still count blank lines as lines, but you get the general idea.