What is the equivalent for LOCK_ESCALATION = TABLE in SQL Server 2005?

Question

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)

Answer 1

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

Answer 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,

Answer 3

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.

Answer 4

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)(http://msdn.microsoft.com/en-us/library/bb326600.aspx)