(local).AdventureWorks Database

Information

NameAdventureWorks
OwnerWin7\Damir
CollationSQL_Latin1_General_CP1_CI_AS
Size 172.00 MB
Create DateMar 29 2010
Version10.0.2531.0
Compatibility Level100

Extended Properties

Object NameObject TypePropertyValue
  MS_DescriptionAdventureWorks Sample OLTP Database

File Information

NameFilenameSizeMax SizeGrowthUsage
AdventureWorks_DataF:\DB\MSSQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf174080 KBUnlimited16384 KBData
AdventureWorks_LogF:\DB\MSSQL\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Log.ldf2048 KB2147483648 KB16384 KBLog

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