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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQLmail

Author  Topic 

WildMan
Starting Member

22 Posts

Posted - 2001-06-07 : 17:31:44
Hello,

I am trying to work with SQL Mail and what I need to be able to do is find out if the SQLMail was sent or not. If it had an error then I need to record that error in the db. I have tried putting Select @@Error right after the mail send statement but it will not get any of the messages that SQL Mail failed.

Does any one know how to gather info on wether the email was sent or not?

Thanks,

Joey

   

- Advertisement -