Table 'dbo.DatabaseLog', Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Table 'dbo.DatabaseLog', Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Property NameProperty Value
Records451
Fields8
Record size (bytes) w/o BLOBs1044

Field statistics for 'DatabaseLogID' int identity

Field propertyProperty Value
Minimum value1
Maximum value451
Average value226.0
Values variance16987.666666666668
Unique values451

Field statistics for 'PostTime' datetime

Field propertyProperty Value
Minimum value2005-10-14 01:58:27.567
Maximum value2005-10-14 02:00:02.460
Unique values423

Field statistics for 'DatabaseUser' sysname(128)

Field propertyProperty Value
Minimum valuedbo
Maximum valuedbo
Unique values1

Field statistics for 'Event' sysname(128)

Field propertyProperty Value
Minimum valueALTER_TABLE
Maximum valueCREATE_XML_SCHEMA_COLLECTION
Unique values13

Field statistics for 'Schema' sysname(128)

Field propertyProperty Value
Minimum valuedbo
Maximum valueSales
Unique values6

Field statistics for 'Object' sysname(128)

Field propertyProperty Value
Minimum value_WA_Sys_00000002_01142BA1
Maximum valueXMLVALUE_Individual_Demographics
Unique values330

Field statistics for 'TSQL' nvarchar(max)

Field propertyProperty Value
Minimum value -- uspLogError logs error information in the ErrorLog...
Maximum value--ENCRYPTED--
Unique values413

Field statistics for 'XmlEvent' xml

Field propertyProperty Value