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

Article translations Article translations
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)
Expand all | Collapse all

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:
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 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.

Properties

Article ID: 238356 - Last Review: October 21, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB238356

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com