|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | DWOperations |
| Default Schema Name | AD\clove |
| Owner | AD\clove |
| Database Collation | SQL_Latin1_General_CP1_CI_AS |
| Data Space Usage (KB) | 15744064 |
| IndexSpaceUsage (KB) | 48872 |
| Space Available (KB) | 3800 |
| Database Size (MB) | 15744064 |
| Database Create Date | 7/31/2013 3:37 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 [DWOperations] Script Date: 03/09/2017 17:21:30 ******/ CREATE DATABASE [DWOperations] ON PRIMARY ( NAME = N'DWOperations_Maintenance', FILENAME = N'E:\sql_data\DWOperations.mdf' , SIZE = 15452160KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'DWOperations_Maintenance_log', FILENAME = N'F:\sql_logs\DWOperations_1.ldf' , SIZE = 291904KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_AS ALTER DATABASE [DWOperations] SET COMPATIBILITY_LEVEL = 100 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [DWOperations].[dbo].[sp_fulltext_database] @action = 'enable' end ALTER DATABASE [DWOperations] SET ANSI_NULL_DEFAULT OFF ALTER DATABASE [DWOperations] SET ANSI_NULLS OFF ALTER DATABASE [DWOperations] SET ANSI_PADDING OFF ALTER DATABASE [DWOperations] SET ANSI_WARNINGS OFF ALTER DATABASE [DWOperations] SET ARITHABORT OFF ALTER DATABASE [DWOperations] SET AUTO_CLOSE OFF ALTER DATABASE [DWOperations] SET AUTO_CREATE_STATISTICS ON ALTER DATABASE [DWOperations] SET AUTO_SHRINK OFF ALTER DATABASE [DWOperations] SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE [DWOperations] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER DATABASE [DWOperations] SET CURSOR_DEFAULT GLOBAL ALTER DATABASE [DWOperations] SET CONCAT_NULL_YIELDS_NULL OFF ALTER DATABASE [DWOperations] SET NUMERIC_ROUNDABORT OFF ALTER DATABASE [DWOperations] SET QUOTED_IDENTIFIER OFF ALTER DATABASE [DWOperations] SET RECURSIVE_TRIGGERS OFF ALTER DATABASE [DWOperations] SET DISABLE_BROKER ALTER DATABASE [DWOperations] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER DATABASE [DWOperations] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER DATABASE [DWOperations] SET TRUSTWORTHY OFF ALTER DATABASE [DWOperations] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER DATABASE [DWOperations] SET PARAMETERIZATION SIMPLE ALTER DATABASE [DWOperations] SET READ_COMMITTED_SNAPSHOT OFF ALTER DATABASE [DWOperations] SET HONOR_BROKER_PRIORITY OFF ALTER DATABASE [DWOperations] SET READ_WRITE ALTER DATABASE [DWOperations] SET RECOVERY SIMPLE ALTER DATABASE [DWOperations] SET MULTI_USER ALTER DATABASE [DWOperations] SET PAGE_VERIFY CHECKSUM ALTER DATABASE [DWOperations] SET DB_CHAINING OFF |
| Powered by BI Documenter |
