Documentation
AdventureWorks2008 Sample OLTP Database - neat! yay!
Documentation generated on: Sep 15 2011 7:37PM
Database objects
Database users
| name | role membership |
|---|
| dbo | db_owner |
| guest | public |
| INFORMATION_SCHEMA | public |
| sys | public |
| testing | db_backupoperator, db_datareader, db_datawriter |
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\AdventureWorks2008_Data.mdf
| PRIMARY
| 185856 KB
| Unlimited
| 16384 KB
| data only
|
| C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks2008_Log.ldf
|
| 2048 KB
| 2147483648 KB
| 16384 KB
| log only
|
Database properties
| name | value |
|---|
| name | AdventureWorks2008 |
| server | SPRING\KATMAI |
| size | 183.50 MB
|
| created | Mar 19 2009 9:09PM |
| 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.02 MB
|
| reserved | 185832 KB
|
| data size | 95240 KB
|
| index size | 82752 KB
|
| unused | 7840 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 [AdventureWorks2008] ON PRIMARY
( NAME = N'AdventureWorks2008_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks2008_Data.mdf' , SIZE = 185856KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB ),
FILEGROUP [DocumentFileStreamGroup] CONTAINS FILESTREAM DEFAULT
( NAME = N'FileStreamDocuments', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\Documents' )
LOG ON
( NAME = N'AdventureWorks2008_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.KATMAI\MSSQL\DATA\AdventureWorks2008_Log.ldf' , SIZE = 2048KB , MAXSIZE = 2048GB , FILEGROWTH = 16384KB )
COLLATE SQL_Latin1_General_CP1_CI_AS
ALTER DATABASE [AdventureWorks2008] SET COMPATIBILITY_LEVEL = 100
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [AdventureWorks2008].[dbo].[sp_fulltext_database] @action = 'enable'
end
ALTER DATABASE [AdventureWorks2008] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE [AdventureWorks2008] SET ANSI_NULLS ON
ALTER DATABASE [AdventureWorks2008] SET ANSI_PADDING ON
ALTER DATABASE [AdventureWorks2008] SET ANSI_WARNINGS ON
ALTER DATABASE [AdventureWorks2008] SET ARITHABORT ON
ALTER DATABASE [AdventureWorks2008] SET AUTO_CLOSE OFF
ALTER DATABASE [AdventureWorks2008] SET AUTO_CREATE_STATISTICS ON
ALTER DATABASE [AdventureWorks2008] SET AUTO_SHRINK OFF
ALTER DATABASE [AdventureWorks2008] SET AUTO_UPDATE_STATISTICS ON
ALTER DATABASE [AdventureWorks2008] SET CURSOR_CLOSE_ON_COMMIT OFF
ALTER DATABASE [AdventureWorks2008] SET CURSOR_DEFAULT GLOBAL
ALTER DATABASE [AdventureWorks2008] SET CONCAT_NULL_YIELDS_NULL ON
ALTER DATABASE [AdventureWorks2008] SET NUMERIC_ROUNDABORT OFF
ALTER DATABASE [AdventureWorks2008] SET QUOTED_IDENTIFIER ON
ALTER DATABASE [AdventureWorks2008] SET RECURSIVE_TRIGGERS OFF
ALTER DATABASE [AdventureWorks2008] SET ENABLE_BROKER
ALTER DATABASE [AdventureWorks2008] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
ALTER DATABASE [AdventureWorks2008] SET DATE_CORRELATION_OPTIMIZATION OFF
ALTER DATABASE [AdventureWorks2008] SET TRUSTWORTHY OFF
ALTER DATABASE [AdventureWorks2008] SET ALLOW_SNAPSHOT_ISOLATION OFF
ALTER DATABASE [AdventureWorks2008] SET PARAMETERIZATION SIMPLE
ALTER DATABASE [AdventureWorks2008] SET READ_COMMITTED_SNAPSHOT OFF
ALTER DATABASE [AdventureWorks2008] SET HONOR_BROKER_PRIORITY OFF
ALTER DATABASE [AdventureWorks2008] SET READ_WRITE
ALTER DATABASE [AdventureWorks2008] SET RECOVERY SIMPLE
ALTER DATABASE [AdventureWorks2008] SET MULTI_USER
ALTER DATABASE [AdventureWorks2008] SET PAGE_VERIFY CHECKSUM
ALTER DATABASE [AdventureWorks2008] 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]
CREATE USER [testing] FOR LOGIN [NT SERVICE\SQLAgent$KATMAI]
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]