Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unhappy Unanswered: File attachment inSQL Stored procedure

    hi,
    i want to send a file as attachment to a specific mailid.i am using sp_SQLSMTPMail sp.how i wlll do it.when im passing the path of the file name,it is giving error.,but it is working fine with sending mail.
    can any body help me
    thanx in advance
    Ashwini
    Code od sp_SQLSMTPMail is attachment.
    when im executing like this:
    exec sp_SQLSMTPMail 'x.yahoo.com','y.yahoo.com','sub','body','cc','bcc ','c:\x.jpg'
    error is giving
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What was the error and try to specify the UNC name such as \\servername\share\path etc.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •