blob: 09e3d4b6eba294388379386ff0a272c48cfdec0c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'@initial.catalog@')
DROP DATABASE [@initial.catalog@]
GO
CREATE DATABASE [@initial.catalog@] ON PRIMARY
( NAME = N'@initial.catalog@_Data', FILENAME = N'@database.path@\@initial.catalog@.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'@initial.catalog@_Log', FILENAME = N'@database.path@\@initial.catalog@.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'@initial.catalog@', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [@initial.catalog@].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [@initial.catalog@] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [@initial.catalog@] SET ANSI_NULLS OFF
GO
ALTER DATABASE [@initial.catalog@] SET ANSI_PADDING OFF
GO
ALTER DATABASE [@initial.catalog@] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [@initial.catalog@] SET ARITHABORT OFF
GO
ALTER DATABASE [@initial.catalog@] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [@initial.catalog@] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [@initial.catalog@] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [@initial.catalog@] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [@initial.catalog@] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [@initial.catalog@] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [@initial.catalog@] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [@initial.catalog@] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [@initial.catalog@] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [@initial.catalog@] SET DISABLE_BROKER
GO
ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [@initial.catalog@] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [@initial.catalog@] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [@initial.catalog@] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [@initial.catalog@] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [@initial.catalog@] SET READ_WRITE
GO
ALTER DATABASE [@initial.catalog@] SET RECOVERY SIMPLE
GO
ALTER DATABASE [@initial.catalog@] SET MULTI_USER
GO
ALTER DATABASE [@initial.catalog@] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [@initial.catalog@] SET DB_CHAINING OFF
|
