Microsoft KB Archive/238356

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

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:

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.

Keywords: kbbug kbfix KB238356

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.