sp_send_dbmail problem

• Mischa E.J. Hoogendoorn

  Mr or Mrs. 500

  Points: 558

  More actions

  October 25, 2012 at 3:41 am

  #269099

  Hello,

  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',

  @recipients='<mymailaddress>',

  @subject = 'Database Mail Test',

  @body = 'This is a test e-mail sent from Database Mail on <server>\<instance>',

  @body_format = 'Text' ;

  select @Error

  When I change the subject or body, the mail will not be send?!

  How can this happen?

  Thanks for your reply...

  Greetings Mischa.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 25, 2012 at 3:49 am

  #1552587

  can you post the complete changed database mail SP call you are using.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Fatherjack

  SSCommitted

  Points: 1575

  More actions

  October 25, 2012 at 4:18 am

  #1552603

  What error message do you get?

• Mischa E.J. Hoogendoorn

  Mr or Mrs. 500

  Points: 558

  More actions

  October 25, 2012 at 4:37 am

  #1552610

  Thanks for the replies! I have the solution, mail was not configured completely. Run this script:

  sp_configure 'show advanced options', 1;

  GO

  RECONFIGURE;

  GO

  sp_configure 'Database Mail XPs', 1;

  GO

  RECONFIGURE

  GO

  Problem solved! I just do not understand why the test message is sending correctly when these options are not set...

  Best regards,

  Mischa

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 25, 2012 at 4:40 am

  #1552617

  Mischa E.J. Hoogendoorn (10/25/2012)

  ---

  I just do not understand why the test message is sending correctly when these options are not set...

  i stil dont believe this , if the mail was not configurd , msgs cant be sent :w00t:

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Mischa E.J. Hoogendoorn

  Mr or Mrs. 500

  Points: 558

  More actions

  October 25, 2012 at 4:48 am

  #1552620

  I just tried it, and it worked... Same server, nothing else changed, except for a reboot.

  Best regards,

  Mischa