|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | EnterpriseDW |
| Default Schema Name | AD\clove |
| Owner | AD\clove |
| Database Collation | SQL_Latin1_General_CP1_CI_AS |
| Data Space Usage (KB) | 20348864 |
| IndexSpaceUsage (KB) | 1462896 |
| Space Available (KB) | 896 |
| Database Size (MB) | 20348864 |
| Database Create Date | 7/31/2013 3:50 PM |
| Database Version | 661 |
| Compatibility Level | Version100 |
| Description |
Database Options
| Property | Value |
| Ansi Null Default | False |
| Ansi Nulls Enabled | False |
| Ansi Padding Enabled | False |
| Ansi Warnings Enabled | False |
| Arithmetic Abort Enabled | False |
| Auto Close | False |
| Auto Create Statistics | True |
| Auto Shrink | False |
| Auto Update Statistics | True |
| Broker Enabled | False |
| Close Cursors On Commit Enabled | False |
| Database Ownership Chaining | False |
| Data Correlation Optimization | False |
| Is Parameterization Forced | False |
| Local Cursors Default | False |
| Numeric Round Abort Enabled | False |
| Page Verify Type | Checksum |
| Quoted Indentifiers Enabled | False |
| Read Only | False |
| Recovery Model | Simple |
| Recursive Triggers Enabled | False |
| Snaphot Isolation State | Disabled |
| Trustworthy | False |
| Database User Access | Multiple |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Database [EnterpriseDW] Script Date: 03/09/2017 17:14:51 ******/ CREATE DATABASE [EnterpriseDW] ON PRIMARY ( NAME = N'EnterpriseDW', FILENAME = N'E:\sql_data\EnterpriseDW_Z.mdf' , SIZE = 13857792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'EnterpriseDW_log', FILENAME = N'F:\sql_logs\EnterpriseDW_1_Z.ldf' , SIZE = 6491072KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS ALTER DATABASE [EnterpriseDW] SET COMPATIBILITY_LEVEL = 100 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [EnterpriseDW].[dbo].[sp_fulltext_database] @action = 'enable' end ALTER DATABASE [EnterpriseDW] SET ANSI_NULL_DEFAULT OFF ALTER DATABASE [EnterpriseDW] SET ANSI_NULLS OFF ALTER DATABASE [EnterpriseDW] SET ANSI_PADDING OFF ALTER DATABASE [EnterpriseDW] SET ANSI_WARNINGS OFF ALTER DATABASE [EnterpriseDW] SET ARITHABORT OFF ALTER DATABASE [EnterpriseDW] SET AUTO_CLOSE OFF ALTER DATABASE [EnterpriseDW] SET AUTO_CREATE_STATISTICS ON ALTER DATABASE [EnterpriseDW] SET AUTO_SHRINK OFF ALTER DATABASE [EnterpriseDW] SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE [EnterpriseDW] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER DATABASE [EnterpriseDW] SET CURSOR_DEFAULT GLOBAL ALTER DATABASE [EnterpriseDW] SET CONCAT_NULL_YIELDS_NULL OFF ALTER DATABASE [EnterpriseDW] SET NUMERIC_ROUNDABORT OFF ALTER DATABASE [EnterpriseDW] SET QUOTED_IDENTIFIER OFF ALTER DATABASE [EnterpriseDW] SET RECURSIVE_TRIGGERS OFF ALTER DATABASE [EnterpriseDW] SET DISABLE_BROKER ALTER DATABASE [EnterpriseDW] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER DATABASE [EnterpriseDW] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER DATABASE [EnterpriseDW] SET TRUSTWORTHY OFF ALTER DATABASE [EnterpriseDW] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER DATABASE [EnterpriseDW] SET PARAMETERIZATION SIMPLE ALTER DATABASE [EnterpriseDW] SET READ_COMMITTED_SNAPSHOT OFF ALTER DATABASE [EnterpriseDW] SET HONOR_BROKER_PRIORITY OFF ALTER DATABASE [EnterpriseDW] SET READ_WRITE ALTER DATABASE [EnterpriseDW] SET RECOVERY SIMPLE ALTER DATABASE [EnterpriseDW] SET MULTI_USER ALTER DATABASE [EnterpriseDW] SET PAGE_VERIFY CHECKSUM ALTER DATABASE [EnterpriseDW] SET DB_CHAINING OFF |
| Powered by BI Documenter |
