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.


Download Exe || Download Source

Thanks,
-Dan