EXCEPTION_ACCESS_VIOLATION error

hi,
I am working on sql 2000 server. Jobs kept randomly
failing on one of my servers with the following error, and
the next runs will be successful randomly, any thought on
this?
'SqlDumpExceptionHandler: Process 72 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process. [SQLSTATE HY000] (Error 0).'
many thanks,
JJIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:427601c4c29e$5cc6f2e0$a301280a@.phx.gbl...
> hi,
> I am working on sql 2000 server. Jobs kept randomly
> failing on one of my servers with the following error, and
> the next runs will be successful randomly, any thought on
> this?
> 'SqlDumpExceptionHandler: Process 72 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process. [SQLSTATE HY000] (Error 0).'
> many thanks,
> JJ|||There should be a sqldumpxxx.txt file in the LOG folder under the MSSQL
folder. This file should show you which processes were running and which
function call choked. You might be cleaver and figure something out;
however, I'm with Armando and agree you should put in a call to MS PSS.
Sincerely,
Anthony Thomas
"Armando Prato" wrote:
> In this case, you may have to call SQL Server support. SQL Server
> has choked on something.
> "JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
> news:427601c4c29e$5cc6f2e0$a301280a@.phx.gbl...
> > hi,
> >
> > I am working on sql 2000 server. Jobs kept randomly
> > failing on one of my servers with the following error, and
> > the next runs will be successful randomly, any thought on
> > this?
> >
> > 'SqlDumpExceptionHandler: Process 72 generated fatal
> > exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> > is terminating this process. [SQLSTATE HY000] (Error 0).'
> >
> > many thanks,
> > JJ
>
>