Article ID: 238356 - View products that this article applies to.
This article was previously published under Q238356
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55738 (SQLBUG_70)
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:
Server: Msg 1203, Level 20, State 1, Line 1
Process ID x attempting to unlock unowned resource
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)
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:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
Contact us for more help
Connect with Answer Desk for expert help.