Hi Alberto,

Funnily enough, there is a way of doing almost the same thing in SQL 2000, but the way you do it is completely different. I used to have a home-mad alerting system running on SQL 2000 a few years ago that created a HTML summary page every 15 minutes from a SQL query result set.

How this worked would take an article in itself to describe, but the basic setup was to call sp_makewebtask with a predefined HTML template to define the HTML output, then call sp_runwebtask from a scheduled job to (re)create the actual HTML file with the formatted SQL query results. The next step of the job was to call SQL Mail with this file as an attachment.

There are all kinds of disadvantages to this method, but within the limitations of these SPs it works well and very reliably. Both SPs are reasonably well documented in Books Online. I hope this helps you.