Quick note - good solution to sending report-formatted data in SQL 2000. With the number of 2000 installs out there, this helps.

Agreed on using DB Mail to send HTML Formatted e-mail and it's relatively easy to drop data into a table. I prefer Reporting Services' Data-driven subscriptions, but in a pinch DB Mail will work.

And I also agree that execs tend to prefer something pushed to them on a regular basis over anything they have to actively retrieve, no matter how easy it is to retrieve it. It's another step to go through to get the data. Well summarized data in an e-mail is easy to digest and determine if they need more details.