Subject Error (long procedure)
Author todderamaa
I have a stored procedure that I run at a few client sights with no
problem. It is quite long and complicated. It goes through a bunch
of data and populates 8 tables with summarized data.

At one client sight I get the error:

"Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements. internal gds software
consistency check (can't continue after bugcheck)."

Then I get a connection lost to database error.


I thought maybe this meant I had some corruption so I backed up and
restored the database and ran the same procedure. I got the same error.

Any ideas would be greatly appreciated.

Todd Brasseur
COMPASS Municipal Services Inc.