At the risk of prompting someone to ask for them, Dan Fernandez has posted a neat stored procedure utility that inspects your sprocs and can give you come basic code metrics on them as well.
If any managers are reading, just remember that code metrics are not a direct measure of productivity. If I spend a week on some existing code and the number of lines of code in it have gone down then I consider that to be a good week....