There's already a system sp to do what you're looking for.  We had to do this same thing just last week.  We modified it a bit to report the size...