| Property | Value |
|---|---|
| Database Name | AdventureWorks2008 |
| Database Id | 12 |
| Description | AdventureWorks2008 Sample OLTP Database update |
| Owner | PROJECTENVISION\Administrator |
| Owner SID | x01050000000000051500000025B2C65A6DE3BF7F151D61F3F4010000 |
| Compatibility Level | 100 |
| Structure Version | 655 |
| Creation Date | 8/8/2010 5:21:02 PM |
| Collation Name | SQL_Latin1_General_CP1_CI_AS |
| State | ONLINE |
| User Access | MULTI USER |
| Recovery Model | SIMPLE |
| Page Verification Option | CHECKSUM |
| Read Only |
|
| Auto Close |
|
| Auto Shrink |
|
| Is Standby |
|
| Fulltext Enabled |
|
| Trustworthy |
|
| DB Chaining |
|
| Forced Parameterization |
|
| Change Data Capture Enabled |
|
| Date Correlation |
|
| Option | Value |
|---|---|
| Auto Create Stats |
|
| Auto Update Stats |
|
| Auto Update Stats Async |
|
| ANSI Null Default On |
|
| ANSI Null On |
|
| ANSI Padding On |
|
| Quoted Identifier |
|
| Concat Null Yields Null |
|
| ANSI Warnings On |
|
| Arithmetic Abort |
|
| Numeric Round Abort |
|
| Recursive Triggers |
|
| Cursor Close On Commit |
|
| Is Local Cursor Default |
|
| Option | Value |
|---|---|
| Master Key Encrypted By Server |
|
| Is Encrypted |
|
| Option | Value |
|---|---|
| Is Published |
|
| Is Subscribed |
|
| Is Distributor |
|
| Sync With Backup |
|
| Option | Value |
|---|---|
| Snapshot Isolation State | OFF |
| Supplemential Logging Enabled |
|
| Is Read Committed Snapshot |
|
| Option | Value |
|---|---|
| Service Broker Guid | 1417c7e4-2945-43f3-b388-05f5406555d0 |
| Broker Enabled |
|
| Broker Priority Honored |
|
| Property | Value |
|---|---|
| Database Size | 227.00 MB |
| Unallocated Space | 24.10 MB |
| Reserved | 184.9 MB |
| Data Space Reserved and Used | 95.91 MB |
| Index Spaced Used | 82.19 MB |
| Unused Space | 6.8 MB |
| Data Space Id | Name | Type | Default | Is Read Only | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|---|
| 2 | DocumentFileStreamGroup | FILESTREAM DATA FILEGROUP |
|
|
||
| 1 | PRIMARY | ROWS FILEGROUP |
|
|
MS_Description | Primary filegroup for the AdventureWorks2008 sample database. mobi update |
| 3 | test1fg | ROWS FILEGROUP |
|
|
MS_Description | aaaa |
| 4 | test2fg | ROWS FILEGROUP |
|
|
||
| 5 | test3fg | ROWS FILEGROUP |
|
|
||
| 6 | test4fg | ROWS FILEGROUP |
|
|
| Filegroup | File Id | Name | Size | Max Size | Growth | Usage | Filename | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|---|---|---|---|
| PRIMARY | 1 | AdventureWorks2008_Data | 195 MB | Unlimited | 16 MB | data only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008_Data.mdf | MS_Description | Primary data file for the AdventureWorks2008 sample database. mobi update |
| test1fg | 3 | test1fg | 5 MB | Unlimited | 1 MB | data only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test1fg.ndf | MS_Description | aaa |
| test2fg | 4 | test2fg | 3 MB | Unlimited | 1 MB | data only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test2fg.ndf | MS_Description | aaaa |
| test3fg | 5 | test3fg | 3 MB | Unlimited | 1 MB | data only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test3fg.ndf | ||
| test4fg | 6 | test4fg | 3 MB | Unlimited | 1 MB | data only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test4fg.ndf |
| File Id | Name | Size | Max Size | Growth | Usage | Filename |
|---|---|---|---|---|---|---|
| 2 | AdventureWorks2008_Log | 18 MB | 2097152 MB | 16 MB | log only | C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008_Log.ldf |