{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Relational Database Management Systems_Unit1_IP

Relational Database Management Systems_Unit1_IP -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
USE [master] GO /****** Object: Database [CCI] Script Date: 01/13/2011 07:41:17 ******/ CREATE DATABASE [CCI] ON PRIMARY ( NAME = N'CCI', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\CCI.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'CCI_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\CCI_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [CCI] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [CCI].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [CCI] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [CCI] SET ANSI_NULLS OFF GO ALTER DATABASE [CCI] SET ANSI_PADDING OFF GO ALTER DATABASE [CCI] SET ANSI_WARNINGS OFF GO ALTER DATABASE [CCI] SET ARITHABORT OFF GO ALTER DATABASE [CCI] SET AUTO_CLOSE OFF GO ALTER DATABASE [CCI] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [CCI] SET AUTO_SHRINK OFF GO
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
ALTER DATABASE [CCI] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [CCI] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [CCI] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [CCI] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [CCI] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [CCI] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [CCI] SET RECURSIVE_TRIGGERS OFF GO
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}