Professional Web Applications Themes

ACCESS_VIOLATION - Microsoft SQL / MS SQL Server

I would give MS PSS a call: [url]http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql[/url] SQL Support [url]http://www.mssqlserver.com/faq/general-pss.asp[/url] MS PSS -- Andrew J. Kelly SQL Server MVP "Eric" <xifeihua> wrote in message news:c9f3602e.0307030955.2f75112eposting.google.c om... > After DBCC Reindex to all the tables in a database (SQL7, SP2), delete > from a table, I got: > > "SqlDumpExceptionHandler: Process 28 generated fatal exception > c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this > process." > > DBCC CHECHDB OR DBCC CHECKALLOC have no error. > I droped all no-PK indexes and recreated them. no help. ANy work > around?...

  1. #1

    Default Re: ACCESS_VIOLATION

    I would give MS PSS a call:


    [url]http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql[/url] SQL Support
    [url]http://www.mssqlserver.com/faq/general-pss.asp[/url] MS PSS

    --

    Andrew J. Kelly
    SQL Server MVP


    "Eric" <xifeihua> wrote in message
    news:c9f3602e.0307030955.2f75112eposting.google.c om...
    > After DBCC Reindex to all the tables in a database (SQL7, SP2), delete
    > from a table, I got:
    >
    > "SqlDumpExceptionHandler: Process 28 generated fatal exception
    > c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this
    > process."
    >
    > DBCC CHECHDB OR DBCC CHECKALLOC have no error.
    > I droped all no-PK indexes and recreated them. no help. ANy work
    > around?

    Andrew J. Kelly Guest

  2. #2

    Default Re: ACCESS_VIOLATION

    And before you do that, unless you want to waste $250 on a unnecessary
    support call, check the doentation for SQL 7 SP3 & 4 to see if the issue
    has been fixed in them. If it is a real bug Microsoft will not charge you
    for the support call, but if it's already fixed in a Service Pack you
    haven't applied yet you will have to pay.


    "Andrew J. Kelly" <sqlmvpnooospamshadhawk.com> wrote in message
    news:OImkfKZQDHA.304tk2msftngp13.phx.gbl...
    > I would give MS PSS a call:
    >
    >
    > [url]http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql[/url] SQL Support
    > [url]http://www.mssqlserver.com/faq/general-pss.asp[/url] MS PSS
    >
    > --
    >
    > Andrew J. Kelly
    > SQL Server MVP
    >
    >
    > "Eric" <xifeihua> wrote in message
    > news:c9f3602e.0307030955.2f75112eposting.google.c om...
    > > After DBCC Reindex to all the tables in a database (SQL7, SP2), delete
    > > from a table, I got:
    > >
    > > "SqlDumpExceptionHandler: Process 28 generated fatal exception
    > > c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this
    > > process."
    > >
    > > DBCC CHECHDB OR DBCC CHECKALLOC have no error.
    > > I droped all no-PK indexes and recreated them. no help. ANy work
    > > around?
    >
    >

    Jacco Schalkwijk Guest

  3. #3

    Default Re: ACCESS_VIOLATION

    Hello,
    It seems that you are most likely running into the problem doented in
    the following KB article (verify by matching the Short Stack Dump):
    Q260742 FIX: DBCC REINDEX Might Cause System Table Referential Integrity
    (http://support.microsoft.com/?id=260742)
    If that is the case, apply SQL70 SP3 to fix the problem.
    Regards,
    Mihir Rao,
    Microsoft SQL Server Support Professional
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Get Secure ! For more info visit http://www.microsoft.com/security. Please
    reply to newsgroups only.

    Mihir Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139