Unable to send mail without attachment

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  February 11, 2011 at 4:46 am

  #234201

  Hi,

  I was able to send mail with attachment only. How can i overcome this.

  The below one executed & sent mail

  EXEC msdb.dbo.sp_send_dbmail

  @recipients=@ToMail,

  @profile_name =@MailPtofile,

  @subject = 'Testing mail account without file',@body='File attachment contains more details',

  ,@file_attachments=@FilePath

  Where as the following code executed and showed in symail_sentitems ,but didnt get mail after waiting for long time also...

  EXEC msdb.dbo.sp_send_dbmail

  @recipients=@ToMail,

  @profile_name =@MailPtofile,

  @subject = 'Testing mail account without file'@body='File attachment or query results size exceeds allowable value.Please contact Admin/Support for more information.'

  After i execute the first script i got mail immdtly....

  Is there any configuration needed to get a mail even attachment not available.

  Thanks,

  Pulivarthi

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 11, 2011 at 7:24 am

  #1285692

  You're missing a comma before @body in the second script. Is that typo in the actual script, or just an error in the post?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon