In this blog post, I gave out script to set up database mail for Sql Server 2005, if you already have smtp server up and running. One thing you need to pay attention to is that Sql Server 2005 logs all those mail messages into msdb database, including mail attachments, if any. You probably can…