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.
| Author |
Topic |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2006-11-17 : 01:31:46
|
Hi All, while our sheduled update stats job was running yesterday it was terminted abnormally and in logs i found the error as:SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this processlater i googled to see what the error is all about and why it failed..i cld gather some info though.. later without any changes made i just ran the job sucessfully, surprising though fyi:iam logging in using SA.. and have all rightscan anyone throw some light on this error or any suggestions plz....its me monty |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-17 : 02:34:31
|
that's an error internally in sql server. It means something in the terminated spid is dereferencing a NULL pointer or some such. what SP and version of sql server are you running? If you are running the latest SP, I would report this to ms.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-18 : 09:49:04
|
| Hi jezemine,its sql server 2000 and sp4 with 2187 cumlative hotfix installedthnxits me monty |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-18 : 10:15:42
|
that's a supported sp, so I would report this to MS if I were you. It would be best if you have a solid repro (but it sounds like you don't). At least tell them in detail the steps that led up to this AV.Still, they should know about it. Give them as much information as you can. Give them everything in the ERRORLOG that looks like it may be applicable, and also a script for creating the agent job if you can.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
|
|
|
Job failed