Re: Why SqlServer always generates "EXCEPTION_ACCESS_VIOLATION" error?
From: Hari (hari_prasad_k_at_hotmail.com)
Date: Sat, 17 Apr 2004 13:25:17 +0530
"EXCEPTION_ACCESS_VIOLATION" generally occurs when SQL is internally raise a
There are various reasons for this exception:-
1. A database corruption - you should identify this by running dbcc
checkdb, newalloc and checkcatalog commands.
2. A hardware problem - usually a problematic memory. Run vendor supplied
diagnostic routines to check out the hardware.
3. A bug in the SQL Server code. This is the Microsoft C code that makes
up SQLSERVR.EXE and associated dll's, NOT your TSQL code.
If you have SQL code that causes an AV it is Microsoft's bug, not
yours. There is nothing anyone outside of Microsoft support can do to help
Apart from this ... What is your service pack level? If it is old please
install the latest service pack and check the exception raises.
If you have the latest service pack please contact Microsoft product support
1. SQL Server Error log
2. Event Logs
3. TSQL code causing vialation
4. Output of Winmsd (contains the Hardware and OS information)
"Neil" <firstname.lastname@example.org> wrote in message
> All error message is:
> SqlDumpExceptionHandler: Process 26 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> It seldom happened before, but always appeared these days. Can anybody
> explain why? Any suggestion will be welcome, thank you!