sql mail

• mmontanari

  Old Hand

  Points: 348

  More actions

  October 28, 2003 at 8:24 am

  #106804

  Hi all

  I have a problem with sql mail. When i execute xp_sendmail with an attachment it fail when i attach the file with a mapped driver reciving the following error

  "Error Description: xp_sendmail: failed with mail error 0x80004005"

  Instead if I put the full path it works. for eample:

  x:\myftp\test.txt dosn't work

  \\dcpt000s020\sim_dati\myftp\test.txt works

  I'm using sql2000 with sp3

  need help

  thanks in advantage

  Marco Montanari

  
  Marco Montanari

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 31, 2003 at 1:58 pm

  #480503

  The drive probably isnt mapped for the SQL Agent account. Using the full network path is a decent method anyway.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn