CODEWITHSUNDEEP
sql-serversql-server-2005sql-server-2008syntaxlocking
Even Mien
Even Mien

Reputation: 45928

What is the equivalent for LOCK_ESCALATION = TABLE in 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.

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

ALTER TABLE dbo.Event SET (LOCK_ESCALATION = TABLE)

Upvotes: 32

Views: 11893

Answers (4)

Michael Freidgeim
Michael Freidgeim

Reputation: 28473

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

Upvotes: 2

Nick Kavadias
Nick Kavadias

Reputation: 7348

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.

Upvotes: 41

gbn
gbn

Reputation: 432471

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,

Upvotes: 6

u07ch
u07ch

Reputation: 13702

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

Upvotes: 0

Related Questions