Post reply

EXCEPTION_ACCESS_VIOLATION Error from a UNION

  • August 6, 2007 at 8:14 am

    #73343

    I am running SQL 2000 SP4 on a WK3 machine.

    When I run two select statements with a UNION I am getting these errors. The first error is from 2005 Management Studio the second error is from 2000 Query Analyzer.

    These two select statements run fine by themselves and I was able to run them last week as a union. I do have a dump file if needed. I've also run DBCC CheckDB and there are no errors.

    Does anyone have any idea why this happens or how to correct it.

    2005 Management Studio:

    Msg 0, Level 19, State 0, Line 4

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

     

    2000 QA:

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

    Server: Msg 11, Level 16, State 1, Line 0

  • August 6, 2007 at 9:38 am

    #724887

     do you get the error only when you run the union or when you run any other query.

    check in your machine sys event log if there was a problem with the network at or around the same time

    Everything you can imagine is real.

  • August 6, 2007 at 9:52 am

    #724896

    bledu,

     

    Thanks for the response.

    It is only this query. I can reproduce it everytime. Actually I found out it wasn't the UNION but a WHERE clause in the UNION. Weird thing is neither query really takes a long time to run (1-2 secs by themselves). I am in the process of rewriting the query.

  • August 6, 2007 at 10:13 am

    #724901

    can you post your query, this sounds very interesting

    Everything you can imagine is real.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply