AdventureWorks Database
Information
| Name | AdventureWorks |
| Owner | VISTA64\Ramajana |
| Collation | SQL_Latin1_General_CP1_CI_AS |
| Size | 181.94 MB |
| Create Date | Mar 21 2007 |
| Version | 611 |
| 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 | C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf | 184256 KB | Unlimited | 16384 KB | Data |
| AdventureWorks_Log | C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Log.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 | |