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