SYMPTOMS
If you try to execute a complex query that has several joins and an execution plan cost of several hundred seconds, it may result in the following floating operation exception that is not valid:
Error: 0, Severity: 19, State: 0
Process %p generated fatal exception c0000090 EXCEPTION_FLT_INVALID_OPERATION. SQL Server is
terminating this process.
This problem occurs during query compilation so it is possible to receive the message if you try to view the execution plan of the complex query.
When you experience this problem, you see the following stack dump in the SQL Server error log file:
SQL Server 7.0 Service Pack 3 Stack Dump
Short Stack Dump
-------------------------------------------------------------------------
0x7800256d Module(MSVCRT+256d) (ftol+1c)
0x00474138 Module(sqlservr+74138) (CTaskContext::SetTaskLimit+e6)
0x004730f2 Module(sqlservr+730f2) (CTask_OptInputs::Perform+7be)
0x004702d7 Module(sqlservr+702d7) (CMemo::ExecuteTasks+144)
0x00470023 Module(sqlservr+70023) (CMemo::OptimizeQuery+480)
0x0046daf1 Module(sqlservr+6daf1) (COptContext::PexprSearchPlan+35f)
0x0044b850 Module(sqlservr+4b850) (COptContext::PcxteOptimizeQuery+7ea)
0x0044afe4 Module(sqlservr+4afe4) (CQuery::Optimize+206)
0x0044ab70 Module(sqlservr+4ab70) (CQuery::Prepare+91)
0x00445f4b Module(sqlservr+45f4b) (CCvtTree::PqryFromTree+7eb)
0x00445c74 Module(sqlservr+45c74) (BuildQueryFromTree+60)
0x00445b13 Module(sqlservr+45b13) (CStmtQuery::InitQuery+c8)
0x0046aa97 Module(sqlservr+6aa97) (CStmtSelect::Init+6c)
0x0043676d Module(sqlservr+3676d) (CCompPlan::FCompileStep+771)
0x0043b503 Module(sqlservr+3b503) (CProchdr::FCompile+5d7)
0x00413dbd Module(sqlservr+13dbd) (CSQLSource::FTransform+233)
0x00480033 Module(sqlservr+80033) (CSQLStrings::FTransform+158)
0x00413923 Module(sqlservr+13923) (CSQLSource::Execute+11c)
0x0047fd57 Module(sqlservr+7fd57) (language_exec+396)
0x41061253 Module(opends60+1253) (execute_event+658)
0x410614a1 Module(opends60+14a1) (process_commands+f2)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+138)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ef0 Module(KERNEL32+4ef0) (lstrcmpiW+be)
-------------------------------------------------------------------------
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 7.0. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack
: The following hotfix was created prior to Microsoft SQL Server 7.0 Service Pack 4.
The following files are available for download from the Microsoft Download
Center:
Intel (x86): Download Intel SQL Server 7.0 patch (s70996i.exe) nowAlpha: Download Alpha SQL Server 7.0 patch (s70996a.exe) now
The S70996i.exe (Intel x86) file contains the following files:
Date Size File name
------------------------------------------
23-May-2001 5,054,736 bytes Sqlservr.exe
14-Jan-2001 586,000 bytes Sqlsort.dll
The S70996a.exe (Alpha) file contains the following files:
Date Size File name
------------------------------------------
23-May-2001 11,664,656 bytes Sqlservr.exe
14-Jan-2001 593,169 bytes Sqlsort.dll
Release Date: 25-May-2001
NOTE: Because of file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
Release Date: May 25, 2001
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.