Sunday, March 11, 2012

An EXCEPTION_ACCESS_VIOLATION during a DELETE...

Our customers server uses SQLServer 7sp4. I don't know too much about the
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.
The
> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for
your
> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>

No comments:

Post a Comment