Microsoft KB Archive/70854

PRSQL9103034: Table Lock Not Escalated with TEXT Datatype ID Number: Q70854

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103034

SYMPTOMS SQL Server does not escalate to a table lock with TEXT datatype in a query with a LIKE clause. Instead, the server will terminate the query and inform the user that the maximum number of locks has been reached.

RESOLUTION Explicitly force a table lock by executing the SELECT statement with a HOLDLOCK when executing a query with a LIKE clause and TEXT datatype.