Configuration: SQL Server Enterprise 2000 SP3a on Windows 2k Advanced
Server.

Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Error: 0, Severity: 19, State: 0
language_exec: Process 53 generated an access violation. SQL Server is
terminating this process.

I can't find anything online about these particular errors. They happen when
I'm inserting records into a database via ADO (.addnew/.update statements in
visual basic.) or when records are being deleted.

Any help would be appreciated.

Thanks,

Chris

AVs are generally the result of SQL Server and other OS bugs... Maybe you
should open a support call... but also look at

http://www.sqlmonster.com/Uwe/Forum.aspx/ms-sql-server/2983/
Odd-Error-in-Event-Viewer

And from another post
hi all, I am here looking for a solution for one of SQL server, detailed
below:

1. Windows2000 server
2. SQL2000, SP3
3. there're several stored procedures accessing a linked server ( built on
Informix ODBC).
4. these stored procedures are set to run every 2 -5 mins by SQLAgentJob.

I found from Task Manager that the VM Size keeps growing time to time but
never drop. (There's 2G RAM in this machine)

After the VM size reaches about 1,400,000K, these stored procedures started
to failed, and a "SqlDumpExceptionHandler: Process 51 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION" error comes out. Moreover,
when checking remote tables in the linked server via Enterprise Manager, a
message of "Failed to allocate memory" prompt out.

After some observation and trial, it is obviously a low VM size will prevent
all above error. I want to find a solution to freeing more VM time by time.
Anyone here have idea? any suggestion or direction??



Show quoteHide quote

What could cause a SQL server not to listen on port 1433?
Building a SQL 2000 server farm
question about AWE and /PAE
SQL server - memory problem
SQL query