Skip to content

Instantly share code, notes, and snippets.

@cphillips83
Created May 20, 2018 10:48
Show Gist options
  • Save cphillips83/10509c361d805201f58bc7c1acae257c to your computer and use it in GitHub Desktop.
Save cphillips83/10509c361d805201f58bc7c1acae257c to your computer and use it in GitHub Desktop.
/* 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.Users ADD
ToSAccepted bit NULL
GO
ALTER TABLE dbo.Users SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment