Microsoft KB Archive/70854: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70854 to Microsoft KB Archive/70854 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:29, 12 August 2020
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.