Article ID: 238356
Article Last Modified on 3/14/2006
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q238356
BUG #: 55738 (SQLBUG_70)
SYMPTOMS
Executing a query that uses at least 25 different tables (for example, a UNION of 25 distinct tables) may fail and return the following errors to the client and then terminate the session:
The SQL Server process is terminated and the last entry found in the error log is the following stack dump:
0x0058f98f Module(sqlservr+18f98f) (ex_raise2+35c) 0x0044f41f Module(sqlservr+4f41f) (ex_raise+5f) 0x006c7972 Module(sqlservr+2c7972) (reportUnlockFailure+8f) 0x0057f85f Module(sqlservr+17f85f) (lck_unlock+d5) 0x00403660 Module(sqlservr+3660) (endscan+68) 0x00403436 Module(sqlservr+3436) (closetable+e8) 0x0058c8ab Module(sqlservr+18c8ab) (clean_process+f5) 0x0058c11f Module(sqlservr+18c11f) (language_exec+5f9) 0x4106187f Module(opends60+187f) (execute_event+659) 0x41061b5d Module(opends60+1b5d) (process_commands+f3) 0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed) 0x4109336a Module(ums+336a) (ThreadStartRoutine+139) 0x7800c0d7 Module(MSVCRT+c0d7) (beginthread+ce) 0x77f04f3e Module(KERNEL32+4f3e) (BaseThreadStart+45)
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
Keywords: kbbug kbfix KB238356