July 14, 2003 at 9:23 am
Recently I upgraded our system from SQL 7 to SQL 2000 (new box, we still have the old one cold). Previously the emails sent using xp_sendmail were being kept in the mailbox of the account specified in the MAPI profile setup on the account used by SQL Server service, since the move to 2000 no sent items.
Can someone advise if I am missing a configuration setting somewhere?
SQL Server Agent is set to keep sent items.
The email account is setup to keep sent items (if I start SQL 7 and use xp_sendmail it pops an email into the sent items).
Thanks in advance! Tom.
July 15, 2003 at 1:09 pm
To anyone who reads this post:
According to MS KB Article: 315886
Q7: Why do I not have any sent messages in the Sent Items folder?
A7: SQL Mail for SQL Server 6.5 and SQL Server 7.0 saves a copy of sent messages in the Sent Items folder of Outlook, which is the default behavior with the simple MAPI interface. Even if you disable this option by clearing the Save copies of messages in Sent Items folder option in the Outlook mail client, the option is ignored.
SQL Mail for SQL Server 2000 is written using the extended MAPI interface and does not save a copy of sent messages in the Sent Items folder. If you need a copy of the messages that SQL Mail sends from SQL Server 2000, you must cc: them to yourself and create an Outlook message rule that routes these message copies to your Sent Items folder.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply