SQL Mail & XP_sendmail in SQL2000

• jwt

  Say Hey Kid

  Points: 668

  More actions

  August 12, 2003 at 3:26 pm

  #106357

  Hello all

  I am trying to run the following SQL statement:

  EXEC master.dbo.xp_sendmail

  @recipients = 'Joey.Sepidoza@ecolab.com',

  @separator = ',',

  @attachments = 'PestErrors.csv' ,

  @message ='test' ,

  @Query = 'SELECT No, Invoice, AccountNo, AccountName,

  Program, SiteCode, SiteName, ConditionCode, ActionCode,

  ConditionCategoryCode, ConditionCategoryDescription,

  ConditionActionDescription, ConditionActionExpanded,

  ServiceDate, ReferenceCode, StoreNumber, AcctNbr

  FROM dbo.Audit

  WHERE ErrorMsg LIKE ''Very Bad %'' AND EmailSent = ''N''',

  @width = 1000,

  @attach_results = 'True',

  @copy_recipients = 'My.Name@MyWork.com' ,

  @subject = 'Errors found'

  I get the following MOST helpful message

  xp_sendmail: failed with operating system error 5

  Anyone seen this before? Any idea on how to fix it?

• winash

  SSChampion

  Points: 11446

  More actions

  August 13, 2003 at 10:49 am

  #469787

  Hi,

  This link might(??) help :

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q296/0/98.ASP&NoWebContent=1

• jwt

  Say Hey Kid

  Points: 668

  More actions

  August 14, 2003 at 6:49 am

  #469921

  Great article - Unfortunately it the fix is for Personal Edition on Windows 98 or ME.

  We are running Standard Edition (sp3) on a 2000 server.

  It is a maddening error - the same query runs fine on a 7.0 box.

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  August 14, 2003 at 7:11 am

  #469935

  Two things: use the three part naming scheme database.owner.table in your FROM clause; specify the complete path to your attachment PestErrors.csv

  Hope this helps.

  Joseph

  
  Joseph