27 lines
1.2 KiB
Transact-SQL
27 lines
1.2 KiB
Transact-SQL
/*
|
||
Thursday, May 23, 20194:04:12 PM
|
||
User:
|
||
Server: FAJITA\DEV_SQL
|
||
Database: DataPRO
|
||
Application:
|
||
*/
|
||
|
||
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
|
||
BEGIN TRANSACTION
|
||
SET QUOTED_IDENTIFIER ON
|
||
SET ARITHABORT ON
|
||
SET NUMERIC_ROUNDABORT OFF
|
||
SET CONCAT_NULL_YIELDS_NULL ON
|
||
SET ANSI_NULLS ON
|
||
SET ANSI_PADDING ON
|
||
SET ANSI_WARNINGS ON
|
||
COMMIT
|
||
BEGIN TRANSACTION
|
||
GO
|
||
ALTER TABLE dbo.TestSetups ADD
|
||
DoStreaming bit NULL
|
||
GO
|
||
ALTER TABLE dbo.TestSetups SET (LOCK_ESCALATION = TABLE)
|
||
GO
|
||
COMMIT
|