Documentation
AdventureWorks Sample OLTP Database
Documentation generated on: Sep 15 2011 7:41PM
Database objects
Database users
| name | role membership |
|---|
| dbo | db_owner |
| guest | public |
| INFORMATION_SCHEMA | public |
| sys | public |
Roles
| name | role id | is application role |
|---|
| public | 0 | 0 |
| db_owner | 16384 | 0 |
| db_accessadmin | 16385 | 0 |
| db_securityadmin | 16386 | 0 |
| db_ddladmin | 16387 | 0 |
| db_backupoperator | 16389 | 0 |
| db_datareader | 16390 | 0 |
| db_datawriter | 16391 | 0 |
| db_denydatareader | 16392 | 0 |
| db_denydatawriter | 16393 | 0 |
Database files
| file | file group | size | max size | growth | usage |
|---|
| C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks_Data.mdf
| PRIMARY
| 174080 KB
| Unlimited
| 16384 KB
| data only
|
| C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks_Log.ldf
|
| 2048 KB
| 2147483648 KB
| 16384 KB
| log only
|
Database properties
| name | value |
|---|
| name | AdventureWorks |
| server | SPRING\KATMAI |
| size | 172.00 MB
|
| created | Mar 19 2009 9:08PM |
| status | ONLINE |
| owner | NT AUTHORITY\SYSTEM |
| version | Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (Intel X86)
Sep 16 2010 20:09:22
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)
|
| unallocated | 0.66 MB
|
| reserved | 173408 KB
|
| data size | 88752 KB
|
| index size | 78568 KB
|
| unused | 6088 KB
|
| compatibility level | 100 |
| updateability | READ_WRITE |
| user access | MULTI_USER |
| recovery | SIMPLE |
| collation | SQL_Latin1_General_CP1_CI_AS |
| SQL sort order | 52 |
| auto close | no |
| auto shrink | no |
| in standby | no |
| torn page detection | no |
| ansi null default | no |
| ansi nulls | yes |
| ansi padding | yes |
| ansi warnings | yes |
| arithmetic abort | yes |
| auto create statistics | yes |
| auto update statistics | yes |
| close cursors on commit | no |
| full text | yes |
| local cursors default | no |
| null concat | yes |
| numeric round abort | no |
| quoted identifiers | yes |
| recursive triggers | no |
| published | no |
| subscribed | no |
| sync with backup | no |
Code (database)
CREATE DATABASE [AdventureWorks] ON PRIMARY
( NAME = N'AdventureWorks_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks_Data.mdf' , SIZE = 174080KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
LOG ON
( NAME = N'AdventureWorks_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks_Log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 16384KB )
COLLATE SQL_Latin1_General_CP1_CI_AS
ALTER DATABASE [AdventureWorks] SET COMPATIBILITY_LEVEL = 100
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [AdventureWorks].[dbo].[sp_fulltext_database] @action = 'enable'
end
ALTER DATABASE [AdventureWorks] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE [AdventureWorks] SET ANSI_NULLS ON
ALTER DATABASE [AdventureWorks] SET ANSI_PADDING ON
ALTER DATABASE [AdventureWorks] SET ANSI_WARNINGS ON
ALTER DATABASE [AdventureWorks] SET ARITHABORT ON
ALTER DATABASE [AdventureWorks] SET AUTO_CLOSE OFF
ALTER DATABASE [AdventureWorks] SET AUTO_CREATE_STATISTICS ON
ALTER DATABASE [AdventureWorks] SET AUTO_SHRINK OFF
ALTER DATABASE [AdventureWorks] SET AUTO_UPDATE_STATISTICS ON
ALTER DATABASE [AdventureWorks] SET CURSOR_CLOSE_ON_COMMIT OFF
ALTER DATABASE [AdventureWorks] SET CURSOR_DEFAULT GLOBAL
ALTER DATABASE [AdventureWorks] SET CONCAT_NULL_YIELDS_NULL ON
ALTER DATABASE [AdventureWorks] SET NUMERIC_ROUNDABORT OFF
ALTER DATABASE [AdventureWorks] SET QUOTED_IDENTIFIER ON
ALTER DATABASE [AdventureWorks] SET RECURSIVE_TRIGGERS OFF
ALTER DATABASE [AdventureWorks] SET ENABLE_BROKER
ALTER DATABASE [AdventureWorks] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
ALTER DATABASE [AdventureWorks] SET DATE_CORRELATION_OPTIMIZATION OFF
ALTER DATABASE [AdventureWorks] SET TRUSTWORTHY OFF
ALTER DATABASE [AdventureWorks] SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE [AdventureWorks] SET PARAMETERIZATION SIMPLE
ALTER DATABASE [AdventureWorks] SET READ_COMMITTED_SNAPSHOT OFF
ALTER DATABASE [AdventureWorks] SET HONOR_BROKER_PRIORITY OFF
ALTER DATABASE [AdventureWorks] SET READ_WRITE
ALTER DATABASE [AdventureWorks] SET RECOVERY SIMPLE
ALTER DATABASE [AdventureWorks] SET MULTI_USER
ALTER DATABASE [AdventureWorks] SET PAGE_VERIFY CHECKSUM
ALTER DATABASE [AdventureWorks] SET DB_CHAINING OFF
Code (users)
CREATE USER [dbo] FOR LOGIN [NT AUTHORITY\SYSTEM] WITH DEFAULT_SCHEMA=[dbo]
CREATE USER [guest] WITH DEFAULT_SCHEMA=[guest]
CREATE USER [INFORMATION_SCHEMA]
CREATE USER [sys]
Code (roles)
CREATE ROLE [db_owner] AUTHORIZATION [dbo]
CREATE ROLE [db_accessadmin] AUTHORIZATION [dbo]
CREATE ROLE [db_securityadmin] AUTHORIZATION [dbo]
CREATE ROLE [db_ddladmin] AUTHORIZATION [dbo]
CREATE ROLE [db_backupoperator] AUTHORIZATION [dbo]
CREATE ROLE [db_datareader] AUTHORIZATION [dbo]
CREATE ROLE [db_datawriter] AUTHORIZATION [dbo]
CREATE ROLE [db_denydatareader] AUTHORIZATION [dbo]
CREATE ROLE [db_denydatawriter] AUTHORIZATION [dbo]