Error: 0, Severity: 19, State: 0

  • While my production sql server was running, suddenly i got the error below and the connection was lost. Can anyone pls guide what is this error for, why this occured and how to resolve it.

    Error: 0, Severity: 19, State: 0

    SqlDumpExceptionHandler: Process 232 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

    Thanks,

     

  • Severity 19 errors are very rare, I would say this sounds as a MS bug. Which sql 2k sp are you running? However, this issue needs further investigation: where did you get the error from? (sql logs, eventvwr, mayby MOM log etc); what was sql running when the error occured?; investigate the memory dump file; are the sql instance min/max memory settings correct?

     

  • I run SQL Server 2000 with SP4 with OS Win 2003. I found this error in event viewer. I am assuming that some procedure was running at this time.

    Pls help me in troubleshooting this issue.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply