FIX: Trace Flag 1211 Does Not Work Properly

ID: Q175546

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 3

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

Additional query words: sp sp3

Keywords : kbusage SSrvGen kbbug6.50.sp3 kbfix6.50.sp4
Version : WINNT:6.5
Platform : WINDOWS
Issue type : kbbug