/DatabaseScript/SQLQuery.sql

  1USE [master]
  2GO
  3
  4/****** Object:  Database [TimeSheetDatabase]    Script Date: 04/19/2010 07:42:09 ******/
  5IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'TimeSheetDatabase')
  6DROP DATABASE [TimeSheetDatabase]
  7GO
  8
  9USE [master]
 10GO
 11
 12/****** Object:  Database [TimeSheetDatabase]    Script Date: 04/19/2010 07:42:09 ******/
 13CREATE DATABASE [TimeSheetDatabase] ON  PRIMARY 
 14( NAME = N'TimeSheetDatabase', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TimeSheetDatabase.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 15 LOG ON 
 16( NAME = N'TimeSheetDatabase_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TimeSheetDatabase_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 17GO
 18
 19ALTER DATABASE [TimeSheetDatabase] SET COMPATIBILITY_LEVEL = 100
 20GO
 21
 22IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
 23begin
 24EXEC [TimeSheetDatabase].[dbo].[sp_fulltext_database] @action = 'enable'
 25end
 26GO
 27
 28ALTER DATABASE [TimeSheetDatabase] SET ANSI_NULL_DEFAULT OFF 
 29GO
 30
 31ALTER DATABASE [TimeSheetDatabase] SET ANSI_NULLS OFF 
 32GO
 33
 34ALTER DATABASE [TimeSheetDatabase] SET ANSI_PADDING OFF 
 35GO
 36
 37ALTER DATABASE [TimeSheetDatabase] SET ANSI_WARNINGS OFF 
 38GO
 39
 40ALTER DATABASE [TimeSheetDatabase] SET ARITHABORT OFF 
 41GO
 42
 43ALTER DATABASE [TimeSheetDatabase] SET AUTO_CLOSE OFF 
 44GO
 45
 46ALTER DATABASE [TimeSheetDatabase] SET AUTO_CREATE_STATISTICS ON 
 47GO
 48
 49ALTER DATABASE [TimeSheetDatabase] SET AUTO_SHRINK OFF 
 50GO
 51
 52ALTER DATABASE [TimeSheetDatabase] SET AUTO_UPDATE_STATISTICS ON 
 53GO
 54
 55ALTER DATABASE [TimeSheetDatabase] SET CURSOR_CLOSE_ON_COMMIT OFF 
 56GO
 57
 58ALTER DATABASE [TimeSheetDatabase] SET CURSOR_DEFAULT  GLOBAL 
 59GO
 60
 61ALTER DATABASE [TimeSheetDatabase] SET CONCAT_NULL_YIELDS_NULL OFF 
 62GO
 63
 64ALTER DATABASE [TimeSheetDatabase] SET NUMERIC_ROUNDABORT OFF 
 65GO
 66
 67ALTER DATABASE [TimeSheetDatabase] SET QUOTED_IDENTIFIER OFF 
 68GO
 69
 70ALTER DATABASE [TimeSheetDatabase] SET RECURSIVE_TRIGGERS OFF 
 71GO
 72
 73ALTER DATABASE [TimeSheetDatabase] SET  DISABLE_BROKER 
 74GO
 75
 76ALTER DATABASE [TimeSheetDatabase] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
 77GO
 78
 79ALTER DATABASE [TimeSheetDatabase] SET DATE_CORRELATION_OPTIMIZATION OFF 
 80GO
 81
 82ALTER DATABASE [TimeSheetDatabase] SET TRUSTWORTHY OFF 
 83GO
 84
 85ALTER DATABASE [TimeSheetDatabase] SET ALLOW_SNAPSHOT_ISOLATION OFF 
 86GO
 87
 88ALTER DATABASE [TimeSheetDatabase] SET PARAMETERIZATION SIMPLE 
 89GO
 90
 91ALTER DATABASE [TimeSheetDatabase] SET READ_COMMITTED_SNAPSHOT OFF 
 92GO
 93
 94ALTER DATABASE [TimeSheetDatabase] SET HONOR_BROKER_PRIORITY OFF 
 95GO
 96
 97ALTER DATABASE [TimeSheetDatabase] SET  READ_WRITE 
 98GO
 99
100ALTER DATABASE [TimeSheetDatabase] SET RECOVERY SIMPLE 
101GO
102
103ALTER DATABASE [TimeSheetDatabase] SET  MULTI_USER 
104GO
105
106ALTER DATABASE [TimeSheetDatabase] SET PAGE_VERIFY CHECKSUM  
107GO
108
109ALTER DATABASE [TimeSheetDatabase] SET DB_CHAINING OFF 
110GO
111
112