I am using SQL Server 2000, SP4/Outlook 2003 SP1/Exchange 2000.

My test email gets sent, but the subject line reamins blank.

xp_startmail
go
xp_sendmail @recipient = '[email protected]', @subject = 'SQL Mail Test', @message = 'Test 1,2,3'
go
xp_stopmail

(I've also tried xp_startmail @user='XXXXXX', @password = 'XXXXXXX'.)

I get the email, with the message, but the subject line is blank.

I've removed and readded my Exchange profile; removed and readded my Exchange email account; restarted the MSSQLSERVER and SQLAgent services; restarted the server; removed and readded the profile to the SQL Server, SQL Agent, and SQL Mail with successful tests; checked and unchecked the Exchange caching mode.

I'm out of ideas. Anyone? Thanks in advance.