My requirement is to disable lock escalation only for a specific table. Is it possible?

[Monty]

Hi, I would like to ask you a question about my health, my requirement is to disable lock escalation only for a specific table. is it possible? Thank you very much for giving me your opinion as soon as possible. Thank you very much in advance.

[Wilfred]

Until SQL Server 2008, there was no way to change the lock escalation for a single table. You could deactivate the escalation for the server by using the Trace Flags:

1211 – Disables Lock Escalation completely – allows to use 60% of the allocated memory – if 60% of memory is used and more locking is needed you will get an out-of-memory error.
1224 – Disables Lock Escalation until the memory threshold of 40% allocated memory is reached – after that Lock Escalation is enabled.