Solving SQLDumpExceptionError

Applies to : SQL Server 2000.

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

Generally this is one of those errors that leaves you clueless about what is happening.Typically one may encounter this type of error when your transaction performs a large number of SQL Operations are performed at once/continuously. Instant solution for this error is to check if you have SP 4 installed for SQL Server. You can verify this by running the following command in Query Analyzer. @@Version . Also below link will give more details about the SQL Server version.

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Now just download SP 4 from from the below link and install it. This should solve the problem. It worked in my case.
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

All the best.