I have recently transferred a couple of databases to a new server running SQL 2000 SP3 (from SQL 7 SP4). I have set up a mail profile through Outlook (exactly the same as on the old machine) and it works fine.
However, I have noticed that mail sent using xp_sendmail is not saved in the Sent Items folder whereas it always was on SQL 7.
SQL Agent mail is saved fine (as there is an option on the mail profile configuration to choose whether you want to save it or not).
Does anyone know if/how you can get all mail saved?
--James
However, I have noticed that mail sent using xp_sendmail is not saved in the Sent Items folder whereas it always was on SQL 7.
SQL Agent mail is saved fine (as there is an option on the mail profile configuration to choose whether you want to save it or not).
Does anyone know if/how you can get all mail saved?
--James