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

sql-server sql-server-2005 sql-server-2008 syntax locking

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 sql-server-2005 sql-server-2008 syntax locking

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,

sql-server sql-server-2005 sql-server-2008 syntax locking

^{@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)

CodeHunter