Wednesday, October 1, 2008

SQL MAIL erro log : Invalid XML message format received on the ExternalMailQueue.

When sending a test email using SQL-MAIL in MS SQL SERVER 2005 (x64) edition, errors has logged in sql log as follows.



Microsoft technet web site said this error can be fixed by installing the SP2 of SQL SERVER.
But i was already installed SP2 and i confused with this situation.
After searching through the internet, Finally i found a solution.

This error comes because of installing the service pack in Cluster environment, sometimes the post scripts (sql queries) didnt run properly. So according to this problem i have to run the following sql query from SQL MANAGMENT STUDIO manually.This was totally solve my problem.

C:\program files\microsoft sql server\mssql.1\mssql\install\sysdbupg.sql

Hope this will help to you.

1 comment:

Deepak Dahiya said...

Men it saved me thanks a lot for this.