Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 08:55:00
|
| Toto writes "I have a problem during processing sql mail attachement via xp_readmail stored procedure. I read those mails that have xml attachement(s).After calling the xp_readmail stored procedure it returns with the name and the path of the attached file (@attachments parameter.) I call this procedure from an ActiveX dll via ADO. But after it, I can't open the file itself (via ADO with a recordset object), because I don't have any rights to open files from that directory.So, my questions are:How can I save the mail attachements into another directory or how can I set up another temporary path for attachments in the MSSQL server 7? Thanks for your help.Bye." |
|
|
|
|
|
SQL mail