What is the equivalent for LOCK_ESCALATION = TABLE

问题:

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

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

ALTER TABLE dbo.Event SET (LOCK_ESCALATION = TABLE)

回答1:

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.

回答2:

There is no equivalent option: it's new in SQL Server 2008.

You'll need to change the "Script For version" to SQL Server 2005,

回答3:

^{@gbn wrote}
"You'll need to change the "Script For version" to SQL Server 2005"

In SQL Server Management Studio 2008 select menu Tools-Options (SQL Server Object Explorer/Scripting Page)

回答4:

In the script generation wizard set the option Script For version to SQL 2005 that should give you the right script.