| Property | Value |
|---|
| Compatibility Level | 110 |
| Database collation | SQL_Latin1_General_CP1_CI_AS |
| Restrict access | MULTI_USER |
| Is read-only | False |
| Auto close | True |
| Auto shrink | False |
| Database status | ONLINE |
| In standby | False |
| Cleanly shutdown | False |
| Supplemental logging enabled | False |
| Snapshot isolation state | OFF |
| Read committed snapshot on | False |
| Recovery model | SIMPLE |
| Page verify option | CHECKSUM |
| Auto create statistics | True |
| Auto update statistics | True |
| Auto update statistics asynchronously | False |
| ANSI NULL default | False |
| ANSI NULL enabled | True |
| ANSI padding enabled | True |
| ANSI warnings enabled | True |
| Arithmetic abort enabled | True |
| Concatenating NULL yields NULL | True |
| Numeric roundabort enabled | False |
| Quoted Identifier On | True |
| Recursive triggers enabled | False |
| Close cursors on commit | False |
| Local cursors by default | False |
| Fulltext enabled | True |
| Trustworthy | False |
| Database chaining | False |
| Forced parameterization | False |
| Master key encrypted by server | False |
| Published | False |
| Subscribed | False |
| Merge published | False |
| Is distribution database | False |
| Sync with backup | False |
| Service broker GUID | 79fc82e3-43cd-4897-9a80-9b057b738673 |
| Service broker enabled | False |
| Log reuse wait | CHECKPOINT |
| Date correlation | False |
| CDC enabled | False |
| Encrypted | False |
| Honor broker priority | False |
| Default language | English |
| Default fulltext language LCID | 1033 |
| Nested triggers enabled | True |
| Transform noise words | False |
| Two-digit year cutoff | 2049 |
| Containment | NONE |
| Target recovery time | 0 |
| Database owner | sa |
AdventureWorks Database
