27 lines
1.2 KiB
Plaintext
27 lines
1.2 KiB
Plaintext
/*
|
|
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
|