AdventureWorks2016CTP3
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 |
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 | ![]() |
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 |
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 |
Extended properties
| Name | Value |
| MS_Description | AdventureWorks 2014 Sample OLTP Database |
See also