check sql mail log

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg - 27 Nov 2008 18:07 GMT

Hi,

I have a sql2000 server, one of the stored procedure runs every day to send
emails out using sql mail. I want to find out the sent email list or log. In
sql 2005, they are stored in the dmv, where can I find on sql 2000? Is there
a table recording this?

Thanks
Sarah

Reply to this Message

Mohit K. Gupta - 27 Nov 2008 22:46 GMT

I don't belive there is one; because SQL Server 2000 actually used MAPI to
send mails. So thats why we had to keep Outlook installed on the server; we
still use that on few servers. I have nothing in sent items of the outlook
either. I don't think there is any trace. Sorry.

Also I don't think anything is being saved in the MSDB far as I know. Thanks.

Signature

Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks
> Sarah

Reply to this Message

sg - 01 Dec 2008 19:44 GMT

Hi Mohit,

This is very useful information, thanks very much,
Sarah

> I don't belive there is one; because SQL Server 2000 actually used MAPI to
> send mails. So thats why we had to keep Outlook installed on the server; we
[quoted text clipped - 12 lines]
> > Thanks
> > Sarah

Reply to this Message