Xp_Sendmail

  • I tried this on my dev, acceptance and prod env :

    xp_sendmail ....,@attachment = '..'

    It works fine on dev and acceptance but not on production. If I remove the @attachment parameter it does work on prod.

    I dont understand why the @attachment does not work on production.

    Thanks.

  • I was using :

    xp_sendmail ....,@attachment='t:\..'

    and I was getting this error :

    Server: Msg 18025, Level 16, State 1, Line 0

    xp_sendmail: failed with mail error 0x80004005

    Instead of that I tried to use this :

    xp_sendmail ..,@attachment='\\server\dir\..'

    and it worked. So just using a UNC name fixed this problem.

    Thanks.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply