FIX: Trace Flag 1211 Does Not Work Properly (175546)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 3
This article was previously published under Q175546
BUG #: 17001 (NT: 6.5.258)

SYMPTOMS

SQL Server 6.5 Service Pack 3 (build 6.5.258) introduced trace flag 1211 to provide additional lock management functionality, such as enabling retry on allocation lock collision. However, if you enable "lock retries" through this trace flag, either at server startup or with the global TRACEON command, you will not see the enhanced behavior.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5 Service Pack 3. This problem was corrected in the latest Microsoft SQL Server 6.5 U.S. Service Pack. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbusage KB175546
©2003 Microsoft Corporation. All rights reserved.