AdventureWorks2016CTP3

CollapseAll image

Collapse image Database information


Name Value
 Name   AdventureWorks2016CTP3 
 Owner   Alen-PC\Alen 
 ID   11 
 Creation Date   13.06.2016 
 Current Compatibility Level   Database compatibility level 130 
 Status   Normal 
 Collation   SQL_Latin1_General_CP1_CI_AS 
 Total Size   1796.31 MB 
 Data Space in Use and Reserved for Use   180768 KB 
 Index Space Usage   115472 KB 
 Allocated and Unused Space   27608 KB 
 Full Text Search Enabled 
 Primary File Path   C:\Program Files\Microsoft SQL Server\MSSQL13.SQLSERVER2016\MSSQL\DATA\AdventureWorks2016CTP3_Data.mdf 
 On Disk Structure Version   852 
 Recovery Model   SIMPLE 
 Containment   NONE 
 File Stream Non-Transacted Access   Off 

Collapse image Database options


Name Value
 Access: Members of db_owner, dbcreator or sysadmin   
 Access: Read Only   
 Access: Single User   
 Cursor Close On Commit   
 Cursors in a Batch are with Local Scope   
 Select Into/Bulkcopy   
 Settings: ANSI NULL default   
 Settings: Auto Close   
 Settings: Auto Create Statistics 
 Settings: Auto Shrink   
 Settings: Auto Update Statistics 
 Settings: Recursive Triggers   
 Settings: Torn Page Detection   
 Settings: Use Quoted Identifiers 
 Truncate Log On Checkpoint 

Collapse image Data files


File name  Location  Space allocated  FileGroup  AutoGrow  Growth  Maximum file size 
AdventureWorks2016CTP3_Data C:\Program Files\Microsoft SQL Server\MSSQL13.SQLSERVER2016\MSSQL\DATA\AdventureWorks2016CTP3_Data.mdf 330048 KB PRIMARY 16384 KB Unlimited

Collapse image Transaction log files


File name  Location  Space allocated  AutoGrow  Growth  Maximum file size 
AdventureWorks2016CTP3_Log C:\Program Files\Microsoft SQL Server\MSSQL13.SQLSERVER2016\MSSQL\DATA\AdventureWorks2016CTP3_Log.ldf 1509376 KB 16384 KB 2147483648 KB

Collapse image Extended properties


Name  Value 
MS_Description AdventureWorks 2014 Sample OLTP Database

Collapse image See also


Database object index