67 lines
2.0 KiB
Transact-SQL
67 lines
2.0 KiB
Transact-SQL
USE [master]
|
|
GO
|
|
|
|
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'TaloyhtioMaster')
|
|
DROP DATABASE [TaloyhtioMaster]
|
|
|
|
/****** Object: Database [TaloyhtioMaster] Script Date: 02/09/2011 21:24:59 ******/
|
|
CREATE DATABASE [TaloyhtioMaster]
|
|
GO
|
|
EXEC dbo.sp_dbcmptlevel @dbname=N'TaloyhtioMaster', @new_cmptlevel=90
|
|
GO
|
|
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
|
|
begin
|
|
EXEC [TaloyhtioMaster].[dbo].[sp_fulltext_database] @action = 'disable'
|
|
end
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ANSI_NULL_DEFAULT OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ANSI_NULLS OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ANSI_PADDING OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ANSI_WARNINGS OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ARITHABORT OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET AUTO_CLOSE OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET AUTO_CREATE_STATISTICS ON
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET AUTO_SHRINK OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET AUTO_UPDATE_STATISTICS ON
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET CURSOR_CLOSE_ON_COMMIT OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET CURSOR_DEFAULT GLOBAL
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET CONCAT_NULL_YIELDS_NULL OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET NUMERIC_ROUNDABORT OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET RECURSIVE_TRIGGERS OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ENABLE_BROKER
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET DATE_CORRELATION_OPTIMIZATION OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET TRUSTWORTHY OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET ALLOW_SNAPSHOT_ISOLATION OFF
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET PARAMETERIZATION SIMPLE
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET READ_WRITE
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET RECOVERY FULL
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET MULTI_USER
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET PAGE_VERIFY CHECKSUM
|
|
GO
|
|
ALTER DATABASE [TaloyhtioMaster] SET DB_CHAINING OFF |