AdventureWorks Database
Information
| Name | AdventureWorks |
| Owner | Win7\Damir |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| Size | 181.94 MB |
| Create Date | Jul 2 2009 |
| Version | 655 |
| Compatibility Level | 90 |
Extended Properties
| Object Name | Object Type | Property | Value |
|---|---|---|---|
| MS_Description | AdventureWorks Sample OLTP Database | ||
File Information
| Name | Filename | Size | Max Size | Growth | Usage |
|---|---|---|---|---|---|
| AdventureWorks_Data | f:\db\mssql\DATA\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks.mdf | 184256 KB | Unlimited | 16384 KB | Data |
| AdventureWorks_Log | f:\db\mssql\DATA\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_1.ldf | 2048 KB | 2147483648 KB | 16384 KB | Log |
Properties
| Ansi Null Default | |
| Ansi Nulls Enabled | |
| Ansi Padding Enabled | |
| Ansi Warnings Enabled | |
| Arithmetic Abort Enabled | |
| Auto Create Statistics | |
| Auto Update Statistics | |
| Auto Close | |
| Auto Shrink | |
| Concatenation of Null yields Null | |
| Close Cursor on Commit Enabled | |
| Dbo Use Only | |
| Local Cursors Default | |
| Merge Publish | |
| Numeric Round Abort Enabled | |
| Offline | |
| Published | |
| Quoted identifier | |
| Read Only | |
| Recursive Triggers | |
| Select Into/Bulkcopy | |
| Single User | |
| Subscribed | |
| Torn Page Detection | |
| Truncate Log on Checkpoint | |