FIX: Trace Flag 1211 Does Not Work Properly
Article ID: 175546
Article Last Modified on 10/3/2003
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
Additional query words: sp sp3
Keywords: kbbug kbfix kbusage KB175546