Database reference - AdventureWorks2008

Database overview

Documentation

AdventureWorks2008 Sample OLTP Database - neat! yay! 

Documentation generated on: Sep 15 2011 7:37PM

Database objects

typecount
tables71
views20
indexes175
procedures10
functions11
all columns744
all parameters51
types6
triggers11
defaults152
schemas18
assemblies1
full text catalogs1
full text indexes3

Database users

namerole membership
dbodb_owner
guestpublic
INFORMATION_SCHEMApublic
syspublic
testingdb_backupoperator, db_datareader, db_datawriter

Roles

namerole idis application role
public00
db_owner163840
db_accessadmin163850
db_securityadmin163860
db_ddladmin163870
db_backupoperator163890
db_datareader163900
db_datawriter163910
db_denydatareader163920
db_denydatawriter163930

Database files

filefile groupsizemax sizegrowthusage
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

namevalue
nameAdventureWorks2008
serverSPRING\KATMAI
size183.50 MB 
createdMar 19 2009 9:09PM
statusONLINE
ownerNT AUTHORITY\SYSTEM
versionMicrosoft 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)
unallocated0.02 MB 
reserved185832 KB 
data size95240 KB 
index size82752 KB 
unused7840 KB 
compatibility level100
updateabilityREAD_WRITE
user accessMULTI_USER
recoverySIMPLE
collationSQL_Latin1_General_CP1_CI_AS
SQL sort order52
auto closeno
auto shrinkno
in standbyno
torn page detectionno
ansi null defaultno
ansi nullsyes
ansi paddingyes
ansi warningsyes
arithmetic abortyes
auto create statisticsyes
auto update statisticsyes
close cursors on commitno
full textyes
local cursors defaultno
null concatyes
numeric round abortno
quoted identifiersyes
recursive triggersno
publishedno
subscribedno
sync with backupno

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]



Documentation generated by SqlSpec