Free cookie consent management tool by TermsFeed Policy Generator

source: stable/HeuristicLab.Services.OKB.DataAccess/3.3/SQL Scripts/Create OKB.sql @ 18235

Last change on this file since 18235 was 8049, checked in by ascheibe, 12 years ago

#1174 integrated OKB services parts into trunk

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