shanila_minnu (5/22/2009)

---

please advise how to create maintanence plan to clean databasemail history ........

Jack Corbett (5/18/2009)

---

In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database mail through it's access protection setting, prevent mass mailing worms from sending mail. When this happens you get the error you listed. You need to add database mail (DatabaseMail90.exe) as an exception to the rule.

Jack Corbett (5/21/2009)

---

As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.

You can change it on your own by going into VirusScan Console -> Double-Click on Access Protection -> Select the Anti-Virus Standard Protection Category -> Select the Prevent mass mailing worms from sending mail -> Click Edit -> Add DatabaseMail90.exe to the processes to exclude -> Click OK -> Click OK -> Exit VirusScan console by clicking the "X" In the upper right.

Again changing it locally will be overwritten by enterprise policy.