|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | DWStaging |
| Default Schema Name | AD\SSIS_ETL |
| Owner | AD\SSIS_ETL |
| Database Collation | SQL_Latin1_General_CP1_CI_AS |
| Data Space Usage (KB) | 138680320 |
| IndexSpaceUsage (KB) | 17346888 |
| Space Available (KB) | 31615936 |
| Database Size (MB) | 138680320 |
| Database Create Date | 7/17/2012 2:22 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 [DWStaging] Script Date: 03/09/2017 16:44:43 ******/ CREATE DATABASE [DWStaging] ON PRIMARY ( NAME = N'DWStaging', FILENAME = N'E:\sql_data\DWStaging.mdf' , SIZE = 123371520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 20480KB ), FILEGROUP [CDC] ( NAME = N'DWStaging_CDC', FILENAME = N'E:\sql_data\DWStaging_1.ndf' , SIZE = 14848000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 20480KB ) LOG ON ( NAME = N'DWStaging_log', FILENAME = N'F:\sql_logs\DWStaging_2.ldf' , SIZE = 460800KB , MAXSIZE = 2048GB , FILEGROWTH = 102400KB ) COLLATE SQL_Latin1_General_CP1_CI_AS ALTER DATABASE [DWStaging] SET COMPATIBILITY_LEVEL = 100 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [DWStaging].[dbo].[sp_fulltext_database] @action = 'enable' end ALTER DATABASE [DWStaging] SET ANSI_NULL_DEFAULT OFF ALTER DATABASE [DWStaging] SET ANSI_NULLS OFF ALTER DATABASE [DWStaging] SET ANSI_PADDING OFF ALTER DATABASE [DWStaging] SET ANSI_WARNINGS OFF ALTER DATABASE [DWStaging] SET ARITHABORT OFF ALTER DATABASE [DWStaging] SET AUTO_CLOSE OFF ALTER DATABASE [DWStaging] SET AUTO_CREATE_STATISTICS ON ALTER DATABASE [DWStaging] SET AUTO_SHRINK OFF ALTER DATABASE [DWStaging] SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE [DWStaging] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER DATABASE [DWStaging] SET CURSOR_DEFAULT GLOBAL ALTER DATABASE [DWStaging] SET CONCAT_NULL_YIELDS_NULL OFF ALTER DATABASE [DWStaging] SET NUMERIC_ROUNDABORT OFF ALTER DATABASE [DWStaging] SET QUOTED_IDENTIFIER OFF ALTER DATABASE [DWStaging] SET RECURSIVE_TRIGGERS OFF ALTER DATABASE [DWStaging] SET DISABLE_BROKER ALTER DATABASE [DWStaging] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER DATABASE [DWStaging] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER DATABASE [DWStaging] SET TRUSTWORTHY OFF ALTER DATABASE [DWStaging] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER DATABASE [DWStaging] SET PARAMETERIZATION SIMPLE ALTER DATABASE [DWStaging] SET READ_COMMITTED_SNAPSHOT OFF ALTER DATABASE [DWStaging] SET HONOR_BROKER_PRIORITY OFF ALTER DATABASE [DWStaging] SET READ_WRITE ALTER DATABASE [DWStaging] SET RECOVERY SIMPLE ALTER DATABASE [DWStaging] SET MULTI_USER ALTER DATABASE [DWStaging] SET PAGE_VERIFY CHECKSUM ALTER DATABASE [DWStaging] SET DB_CHAINING OFF |
| Powered by BI Documenter |
