You are currently offline, waiting for your internet to reconnect

FIX: Use of 25 Different Tables in a Query May Raise Error 1203

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:
Server: Msg 1203, Level 20, State 1, Line 1
Process ID x attempting to unlock unowned resource
The SQL Server process is terminated and the last entry found in theerror 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)					
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.

Article ID: 238356 - Last Review: 10/21/2013 23:22:01 - Revision: 2.1

Microsoft SQL Server 7.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix KB238356