I've got a very strange problem, I can send mail with the following statement:
declare @Error int
EXEC @Error = msdb.dbo.sp_send_dbmail
@profile_name = 'SQL Mail',
@subject = 'Database Mail Test',
@body = 'This is a test e-mail sent from Database Mail on <server>\<instance>',
@body_format = 'Text' ;
When I change the subject or body, the mail will not be send?!
How can this happen?
Thanks for your reply...