BOL: "An Introduction to SQL Mail and SQLAgentMail
By Mike Gunderloy
Making connections between software applications is in style. XML and .NET are just the most visible components of a drive to make everything talk to everything else. We're all in for a lot of learning over the next few years while we figure out how to make
our applications work together as Web services. Sometimes, though, it's worth remembering that older technology can still work very well. One such tried and true technology is the connection between Microsoft SQL Server and e-mail.
SQL Server 2000 and SQL Server 7.0 are fully integrated with e-mail. You can use SQL Server's e-mail integration to perform a variety of tasks:
Accept queries via e-mail
Send results back via e-mail
Notify operators of job success or failure via e-mail or pager
In this article, you will learn how to set up and use the e-mail services in Microsoft SQL Server 2000. Most of what you'll learn applies equally well to Microsoft SQL Server 7.0. You'll discover that it's actually rather simple to integrate your back-end
database with your e-mail system. "