Re: Why SqlServer always generates "EXCEPTION_ACCESS_VIOLATION" error?

From: Hari (
Date: 04/17/04

  • Next message: Nick: "Lost Contact with MSDE"
    Date: Sat, 17 Apr 2004 13:25:17 +0530

    Hi Neil,

    "EXCEPTION_ACCESS_VIOLATION" generally occurs when SQL is internally raise a
    access violation.

    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" <> 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!
    > --
    > Neil

  • Next message: Nick: "Lost Contact with MSDE"