|
|
> Hi.
> From my dektop PC I started Query Analyser on 12 servers and used it to
> execute a Stored Procedure (same database structure on all servers). On eight
> it worked, on four it did not, giving the message:
>
> ODBC: Msg 0, Level 19,. State 1
> SqlDumpExceptionHand
ler: Process nnn generated fatal exception c0000005
> EXCEPTION_ACCESS_VIO
LATION. SQL Server is terminating this process.
>
> Connection broken
>
> Can someone tell me what is going on and how to get round this? The Stored
> Procedure is like this:
>
> CREATE TABLE... (no problem here)
> INSERT INTO.... several thousand rows generated by reading a million plus
> rows
> from a different database on the same server
> (this sometimes works, sometimes it fails at
> this point)
> UPDATE... all the rows from the INSERT, again with data generated by
> reading a
> million plus rows from a different database on the same
> server
> (if it gets beyond this point it works
> correctly)
> UPDATE... as the first update
> UPDATE... as the first update
> similar UPDATE... INSERT... UPDATE... UPDATE... UPDATE... UPDATE
>
> A valid run takes about 10-15 minutes. The last one I tried failed during
> the first UPDATE after 26 seconds.
>
> TIA,
>
> Peter.
User submitted from AEWNET (http://www.aewnet.com/)
|
|