Skip to content

Instantly share code, notes, and snippets.

@egbutter
Last active August 29, 2015 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save egbutter/c500ff6276c66c9ba4aa to your computer and use it in GitHub Desktop.
Save egbutter/c500ff6276c66c9ba4aa to your computer and use it in GitHub Desktop.
Simple example of arithabort being turned off on sql server
USE [master]
GO
CREATE DATABASE [TestDb]
GO
ALTER DATABASE [TestDb] SET COMPATIBILITY_LEVEL = 90
GO
ALTER DATABASE [TestDb] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [TestDb] SET ARITHABORT OFF
GO
USE [TestDb]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[xxTest](
[SOME_THING] int NOT NULL,
[IS_ON] [bit] NOT NULL,
PRIMARY KEY CLUSTERED
(
[SOME_THING] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [TestDb] SET READ_WRITE
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment