SQL Server Q&A

Symptoms
Running a query with two or more nested IN clauses and a CASE statement may cause the connection to be broken and the following error to be returned:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Connection Broken
Resolution
The query caused a handled exception in SQL Server, and the process was stopped.

Symptoms
Any string that is longer than 8000 bytes that is given as a second parameter to the xp_logevent stored procedure, causes the following error message to occur:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
ODBC: Msg 0, Level 20, State 1
Stored function ‘xp_logevent’ in the library ‘xplog70.dll’ generated an
access violation. SQL Server is terminating process 51.
Resolution
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
290211?(http://support.microsoft.com/kb/290211/EN-US/) INF: How to Obtain the Latest SQL Server 2000 Service Pack

Symptoms
When you run a coalesce query that contains a subquery the following error message may occur:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Resolution
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
290211?(http://support.microsoft.com/kb/290211/EN-US/) INF: How to Obtain the Latest SQL Server 2000 Service Pack

Symptoms
Using a SELECT statement with a WHERE clause against a FLOAT datatype, with auto create statistics, may return an error. The auto create statistics may not appear when executing SP_HELPINDEX. Attempting to use DROP then CREATE STATISTICS may also return the following error:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 12 generated fatal exception c0000090 EXCEPTION_FLT_INVALID_OPERATION. SQL Server is terminating this process.This bug does not occur until a significant number of rows have been inserted into a table containing a FLOAT datatype.
Resolution
Change the datatype in the table from FLOAT to DECIMAL or NUMERIC.

Symptoms
A SELECT statement that uses the four-part name against a linked server, might generate an access violation if all of the following conditions are met:The OLE DB provider for ODBC Driver is chosen to create the linked server.
The name of one unique index (for example,PK_index) is a shortened name of another unique clustered index (for example, PK_index_1__14) on the same table.
The unique clustered index includes the columns from the other unique index as part of its key.The query fails with an error message similar to the following:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection BrokenThe short stack trace seen in the errorlog for the preceding spid is:

0×00574b4c Module(sqlservr+174b4c) (CTableMetadata::GatherGroupProperties+290)0×00622298 Module(sqlservr+222298) (CTableMetadata::LoadMetadata+19c)0×006221ac Module(sqlservr+2221ac) (CCvtTree::LoadAllMetadata+7c)0×00620888 Module(sqlservr+220888) (CCvtTree::PqryFromTree+dec)0×00621d5c Module(sqlservr+221d5c) (BuildQueryFromTree+8c)0×00621ef0 Module(sqlservr+221ef0) (CStmtQuery::InitQuery+184)0×00619b08 Module(sqlservr+219b08) (CStmtSelect::Init+cc)0×0052266c Module(sqlservr+12266c) (CCompPlan::FCompileStep+b98)0×004cf1a8 Module(sqlservr+cf1a8) (CProchdr::FCompile+7f0)0×004e0580 Module(sqlservr+e0580) (CSQLSource::FTransform+384)0×004e0100 Module(sqlservr+e0100) (CSQLStrings::FTransform+208)0×004c04ec Module(sqlservr+c04ec) (CSQLStrings::Compile+8c)0×004e5180 Module(sqlservr+e5180) (CStmtPrepQuery::CStmtPrepQuery+478)0×004ea238 Module(sqlservr+ea238) (CCompPlan::FCompileStep+184)0×004cf1a8 Module(sqlservr+cf1a8) (CProchdr::FCompile+7f0)0×004e0580 Module(sqlservr+e0580) (CSQLSource::FTransform+384)0×004e0100 Module(sqlservr+e0100) (CSQLStrings::FTransform+208)0×004de68c Module(sqlservr+de68c) (CSQLSource::Execute+14c)0×004dec24 Module(sqlservr+dec24) (language_exec+638)0×41066ea4 Module(opends60+6ea4) (execute_event+7a0)0×41067524 Module(opends60+7524) (process_commands+144)0×410a3620 Module(ums+3620) (ProcessWorkRequests+154)0×410a2af0 Module(ums+2af0) (ThreadStartRoutine+16c)0×780168e8 Module(MSVCRT+168e8) (endthread+fc)0×77e6cc48 Module(KERNEL32+cc48) (lstrcmpiW+128)2000-05-26 11:58:36.76 spid8CImageHelper::GetSym Error – The specified Module could not be found.2000-05-26 11:58:38.39 spid8Error: 0, Severity: 19, State: 02000-05-26 11:58:38.39 spid8language_exec: Process 8 generated an access violation. SQL Server is terminating this process.2000-05-28 11:00:43.96 spid8Using ’sqlimage.dll’ version ‘4.0.5′ Stack Dump being sent to C:\MSSQL7\log\SQL00002.dmp2000-05-28 11:01:03.65 spid8Error: 0, Severity: 19, State: 02000-05-28 11:01:03.65 spid8SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Resolution
To work around this problem you can either:Select the OLE DB provider for SQL Server to create the linked server.
-or-
Change the index name.