I didn't realize that the generated email was text. I was confused by the html table displayed under "Pretty" Output in the article. Nice job on the technique....

Can someone comment on my question regarding html tags? Does bbry not require these?

I don't think Database.Mail is available in SQL 2000.

We actually use something called sp_send_cdosysmail. We found it on this site and it works well for us. I also found it on Microsoft's website, so I don't...

Austin,

This looks like a great solution. Quick question: I don't see any html tags (html, body, etc.).

How does the bbry know how to interpret the data? I'm not familiar...

I've had to link on a previous row in the past. I've just used self joins, i.e. joining a table on itself. In the join clause, I just...

Jeff,

Thanks for the link.  It turned out that it was the DTC on the Windows 2003 Server.  I am running Windows 2000 on one server and 2003 on the other...

Steve,

I found the following article:

http://www.mcse.ms/archive/index.php/t-1425692.html

It seems to have moved me farther along the way (I now get an error message as opposed to a hung query). The...