We have a 2000 server -- 5.00.2195 SP4 running Sql Server 2000 SP3, and are experiencing a strange SQL Mail issue.
SQL Mail is configured using an MS Exchange profile and runs for anywhere from a few days to a few weeks. However, during
this time, it generates Demo 19 errors in SQL Server when some (but not all) of our emails are sent out. The short
stack dumps for all of these errors are identical --
* Short Stack Dump
* 77F8206B Module(ntdll+0000206B) (RtlEnterCriticalSection+0000000B)
* 77E14605 Module(USER32+00004605) (TranslateMessageEx+00000605)
* 77E15B77 Module(USER32+00005B77) (DispatchMessageA+0000000B)
* 7E816608 Module(UNKNOWN+00000000)
Eventually, SQL Mail fails completely and hangs and only a complete restart of the server (not "sp_stopmail")
will get it working again. Can anyone tell me what is causing this issue? I'm getting the impression it's probably
some kind of configuration problem, but I'm not knowledgible enough to know where to begin. Any pointers would be a
Also, there's an interesting "side issue" I'd like to understand -- we have a table which contains several Insert and Update
triggers that send out emails using xp_SendMail. When the SQL Mail server hangs, "select" statements on this table
which use a where clause hang-- but those without a where clause execute fine. It's pretty clear that SQL Server gets
hung up on the xp_sendmail reference in the trigger when it attempts to do a select with a "where" clause, but not when it
doesn't have a where clause. Can anyone explain this behavior to me?
I really appreciate any help on this one -- we're all stumped!