Issue sending email with attachment from DB mail

• juanfvc

  Valued Member

  Points: 68

  More actions

  November 9, 2008 at 4:05 pm

  #92819

  Hello,

  I have a problem, I have been trying to send an email (From DB server) by SMTP located in the Web server. I'm able to sent emails but only if it does not have attachment included. This is a weird behaivor at least for me.

  All that I got is this message:

  "Message

  DatabaseMail process is shutting down" of the mail log.

  I'm using this code:

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name = 'SQL Database Mail',

  @recipients = 'XX@XX.com',

  @subject = 'Daily Report',

  @body = 'Here is your text...',

  @file_attachments = 'C:\reports\file.csv';

  Do somebody have an idea what the problem can be??? :w00t:

  Thanks in advance.

• juanfvc

  Valued Member

  Points: 68

  More actions

  November 9, 2008 at 4:09 pm

  #896089

  BTW like three months ago this process was working correctly.. :crying:, And I have not changed nothing since then.

  thanks

• tfifield

  SSCrazy Eights

  Points: 9655

  More actions

  November 10, 2008 at 2:20 pm

  #896575

  If nothing has changed on your SQL Server, then there must be some change on the SMTP server. Some security or SPAM setting?

  Todd Fifield

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  November 11, 2008 at 1:56 am

  #896794

  Check security rights on temp directory, since file is created there before attached to message.

  ---

  N 56°04'39.16"
  E 12°55'05.25"