USE [master]
GO
/****** Object: Database [CTUApril2015] Script Date: 4/13/2015 8:05:37 PM ******/
CREATE DATABASE [CTUApril2015] CONTAINMENT = NONE ON PRIMARY
( NAME = N'CTUApril2015', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\CTUApril2015.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON
( NAME = N'CTUApril2015_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\CTUApril2015_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [CTUApril2015] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [CTUApril2015].[dbo].[sp_fulltext_database] @action = 'enable' end GO
ALTER DATABASE [CTUApril2015] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [CTUApril2015] SET ANSI_NULLS OFF
GO
ALTER DATABASE [CTUApril2015] SET ANSI_PADDING OFF
GO
ALTER DATABASE [CTUApril2015] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [CTUApril2015] SET ARITHABORT OFF
GO
ALTER DATABASE [CTUApril2015] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [CTUApril2015] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [CTUApril2015] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [CTUApril2015] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [CTUApril2015] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [CTUApril2015] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [CTUApril2015] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [CTUApril2015] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [CTUApril2015] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [CTUApril2015] SET DISABLE_BROKER
GO
ALTER DATABASE [CTUApril2015] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [CTUApril2015] SET DATE_CORRELATION_OPTIMIZATION