I am trying to send mail from SQL Server 2000 but when the email is delivered, the subject line is empty.
I have looked through the forums here and found someone with the same problem which they fixed it by reverting to a previous version of Outlook. Unfortunately, I'm not in a position to be able to do that.
I've also entered:
sql server xp_sendmail subject
into Google, and gone through the first 22 pages of results, but to no avail.
Here is what I have done:
I have a machine nwb-xtest-beta, running Windows XP Pro, with all OS updates, and logged in as "xtest".
I am running SQL Server 2000, with SP2.
I have installed Outlook 2003, installed all the updates available to it, configured a profile ("XTest") and sent and received email fine.
I configured the MSSQLSERVER service to be started as user corpdom\xtest, and restarted the service.
I went to Enterprise manager, Support Services, SQL Mail, and selected XTest from the list of profiles.
I then went to Query Analyzer, and ran:
EXEC xp_sendmail 'rupertw', @subject="test subject", @message="test message"
The message was delivered, but with an empty subject line. There was no subject in the SMTP headers (i.e. there was nothing after Subject: ).
I wondered if it was a problem which had been fixed with a later service pack, so I went to my machine - nwb-rupertw (so I could be sure that it was the application of the SP which had fixed it), running the same software, but configured everything as user "rupertw".
Executing the same SQL statement worked, including a good subject line.
I went back to nwb-xtest-beta and reconfigured everything using the "rupertw" id. Again, it all worked, including good subject line.
No errors reported in event viewer.
It would imply that there is a difference in how xp_sendmail sees the different users, tho I've been told that they're the same.
Has anyone got a suggested solution to this problem?