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 Administration (2000)
 SQL Mail intermittent issues

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-10 : 07:31:43
BB writes "Ok. This issue is not covered (at least from the searches that I have done).

I am pretty sure I have SQL mail configured right, but sometimes it fails. There are no event or SQL logs. I set up a table with trigger. The trigger (insert/update) runs xp_sendmail. It is just a simple text notification. Is there a way to generate a log if SQL mail or the insert/update fails?

HEEEEELLLLLPPPPPPP!!!!!!!"
   

- Advertisement -