Article ID: 327424
Article Last Modified on 10/23/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q327424
SYMPTOMS
You receive one of the following error messages:
- When you connect to SQL Server 7.0 from SQL Server Enterprise Manager: -Or-
- When you click Alerts under SQL Server Agent in SQL Server Enterprise Manager:
Additionally, the Errorlog file in SQL Server 7.0 contains one of the following stack dumps:
SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.
SQL Server is terminating this process.
.
*******************************************************************************
*
* BEGIN STACK DUMP:
* 0x/xx/02 03:12:54 spid 7
*
* Exception Address = 04004697 (Ordinal6 + 297)
* Exception Code = c0000005 E
* Access Violation occurred writing address 00000004
* Input Buffer 54 bytes -
* e x e c s p _ M S d b u s e r p r i v N ' v e r '
*
...
-------
Short Stack Dump
0x04004697 Module(sqlsort+4697) (Ordinal6+297)
0x005bea83 Module(sqlservr+1bea83) (GetUnicodeRange+e7)
0x00575825 Module(sqlservr+175825) (CLikeRangeUtil::LikeRangeTransW+2ec)
0x00647680 Module(sqlservr+247680) (CXVariant::LikeRangeStart+7b)
0x0056d35b Module(sqlservr+16d35b) (COptExpr::PexprFoldMain+103c)
0x00443d71 Module(sqlservr+43d71) (COptExpr::PexprFoldMain+b8)
0x00443c08 Module(sqlservr+43c08) (COptExpr::PexprFold+3f)
0x004e0d3b Module(sqlservr+e0d3b) (CCvtTree::BuildSte+12e)
0x004e0c15 Module(sqlservr+e0c15) (BuildSteFromTree+39)
0x004e0b97 Module(sqlservr+e0b97) (CStmtCond::Init+4e)
0x00438530 Module(sqlservr+38530) (CCompPlan::FCompileStep+f23)
0x0043d00f Module(sqlservr+3d00f) (CProchdr::FCompile+5d9)
0x0040ec53 Module(sqlservr+ec53) (CSQLSource::FTransform+234)
0x0042140c Module(sqlservr+2140c) (CSQLObject::FTransform2+1ab)
0x004e1cdc Module(sqlservr+e1cdc) (CSQLObject::FGetFromDisk+627)
0x00420f96 Module(sqlservr+20f96) (CSQLObject::FTransform+21a)
0x0040e7b9 Module(sqlservr+e7b9) (CSQLSource::Execute+11d)
0x0046225f Module(sqlservr+6225f) (CStmtExec::XretLocalExec+127)
0x0046211e Module(sqlservr+6211e) (CStmtExec::XretExecute+253)
0x0040f487 Module(sqlservr+f487) (CMsqlExecContext::ExecuteStmts+11b)
0x0040ef35 Module(sqlservr+ef35) (CMsqlExecContext::Execute+16b)
---------------------------------------------------------------------------
Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.
-Or-
*******************************************************************************
*
* BEGIN STACK DUMP:
* 0x/xx/02 16:49:07 spid 7
*
* Exception Address = 105B498A
* Exception Code = c0000005 E
* Access Violation occurred reading address FFFFFFFF
* Input Buffer 54 bytes -
* e x e c s p _ M S d b u s e r p r i v N ' v e r '
.........
Short Stack Dump
0x105b498a Module(UNKNOWN+0)
---------------------------------------------------------------------------
Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.
***************************************************************************
*
* BEGIN STACK DUMP:
* 0x/xx/02 16:47:50 spid 7
*
* Exception Address = 105B48FA
* Exception Code = c0000096 E
* Input Buffer 188 bytes -
* E X E C U T E m s d b . d b o . s p _ h e l p _ a l e r t @ o r d e
* r _ b y = N ' s e v e r i t y A S C , m e s s a g e _ i d A S
* C , d a t a b a s e _ n a m e D E S C '
*
---------------------------------------------------------------------------
Short Stack Dump
0x105b48fa Module(UNKNOWN+0)
---------------------------------------------------------------------------
Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.
CAUSE
This behavior occurs if the versions of Sqlsort.dll and Sqlservr.exe are not compatible.
RESOLUTION
To resolve this behavior, make sure that the version of Sqlsort.dll is compatible with your version of SQL Server 7.0. For additional information about how to determine the version of the existing SQL Server 7.0 build, click the article number below to view the article in the Microsoft Knowledge Base:
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
After you verify the version of SQL Server 7.0, verify the version of Sqlsort.dll to make sure that it is compatible (to verify compatibility, look at the following table). This .dll file is located in the MSSQL7\binn folder.
Sqlsort.dll is included in SQL Server 7.0 SP3 and later, in the post-SQL 7.0 SP3 security update, and in other fixes. The following table summarizes the Sqlsort.dll file version and the matching Sqlservr.exe file version. If you experience the symptoms in this article, use the table to identify and to replace the Sqlsort.dll file with the correct version.
| Sqlsort.dll File Version | Compatible Sqlservr.exe File Version | Related Article |
|---|---|---|
| 7.00.961 | 7.00.961 |
274797 INF: SQL Server 7.0 Service Pack 3 Fix list
|
| 7.00.978 | 7.00.978 |
285870 FIX: Update With Self Join May Update Incorrect Number Of Rows
|
| 7.00.978 | 7.00.996 |
299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have
318053 FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation
|
| 7.00.978 | 7.00.1004 |
308126 FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented
|
| 7.00.0978 | 7.00.1012 |
311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128
|
| 7.00.0978 | 7.00.1016 |
314117 FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr
|
| 7.00.0978 | 7.00.1020 |
304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers
|
| 7.00.994 | 7.00.994 |
298643 FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values
|
| 7.00.1021 | 7.00.1021 |
317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source
|
| 7.00.1021 | 7.00.1028 |
319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers
|
| 7.00.1021 | 7.00.1026 (SP3-based) or 7.00.1071 (SP4-based) |
319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED
|
| 7.00.1021 | 7.00.1033 |
324469 FIX: Error Message 9004 May Occur When You Restore a Log That Does Not Contain Any Transactions
|
| 7.00.1063 | 7.00.1063 | SQL Server 7.0 Service Pack 4 |
MORE INFORMATION
The following stored procedure runs when you connect to SQL Server 7.0 from SQL Server Enterprise Manager:
EXEC sp_MSdbuserpriv N'ver'
The following stored procedure runs when you click Alerts under SQL Server Agent in SQL Server Enterprise Manager:
EXEC msdb.dbo.sp_help_alert @order_by = N'severity ASC, message_id ASC, database_name DESC'
NOTE: When you run these stored procedures in SQL Query Analyzer, a similar access violation occurs:
Additional query words: Access violation sqlsort.dll service pack build sp_MSdbuserpriv sqlservr.exe sp_help_alert AV 70
Keywords: kbnofix kbprb KB327424
