SQL Server 2005中LOCK_ESCALATION = TABLE的等效项是什么? [英] What is the equivalent for LOCK_ESCALATION = TABLE in SQL Server 2005?

问题描述

我有一个在SQL Server 2008中生成的脚本，但是我需要针对SQL Server 2005数据库执行该脚本.

I have a script that was generated in SQL Server 2008, but I need to execute it against a SQL Server 2005 database.

在SQL Server 2005中，以下等效语句是什么?

What would an equivalent statement for the following be in SQL Server 2005?

ALTER TABLE dbo.Event SET (LOCK_ESCALATION = TABLE)

推荐答案

LOCK_ESCALATION = TABLE是SQL Server 2008和更高版本中的默认行为.是SQL Server 2005中的唯一行为.

LOCK_ESCALATION = TABLE is the default behavior in SQL Server 2008 & is the ONLY behaviour in SQL Server 2005.

您可以放心地删除该语句，而无需进行任何功能上的更改.

You can safely drop the statement without any change in functionality.

这篇关于SQL Server 2005中LOCK_ESCALATION = TABLE的等效项是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！