February 26, 2004 at 8:26 am
Hi experts,
Recently, we got SQL Server error message almost every morning as following:
** (Our SQL Server 2000 has installed Service Pack 3a)
Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to D:\Microsoft SQL Server\MSSQL\log\SQL00008.dmp
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 69 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* BEGIN STACK DUMP:
* 02/25/04 07:04:56 spid 69
*
* Exception Address = 77F8910E (RtlAllocateAndInitializeSid + 0000004C Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0422FF90
* Input Buffer 12 bytes -
* Alerts_Email
*
Does anyone know why we have this error and is it causing any problem and how to handle it?
Thank you.
February 26, 2004 at 8:41 am
Contact Microsoft PSS and send the dump files to them for investigation.
February 26, 2004 at 9:42 am
2nd vote for Allen's suggestion. you might also run sqldiag and send that as well.
May 10, 2005 at 7:52 am
I don't know if this is still an issue for you, but you should check out MS knowledge base article 839405, which indicates a stack dump very simlar to yours. It's regarding Sql Mail problems on multi-processor computers. I see your issue is a sql alerts email issue, but many of the components used are the same between sql alerts email and sql mail proper.
You may also want to take a look at your MAPI dll's, which can get out of sync and cause this sort of problem. I'm currently fighting a similar problem, and the following web cast transcript has been useful to me:
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc091301/WCT091301.asp
I hope this helps!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply