Dbo.DatabaseLog (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:15Z

Bot at 21:59, 23 June 2010

2010-06-23T21:59:27Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:25Z

Bot at 22:24, 28 December 2009

2009-12-28T22:24:49Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:24Z

Bot at 05:58, 30 November 2009

2009-11-30T05:58:49Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:11Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:02Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:29Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:27Z

@@ Line 89: / Line 89: @@
 | Insert
 | Database Trigger
-| [[ddlDatabaseTriggerLog_(_(database_trigger))|ddlDatabaseTriggerLog]]
+| [[ddlDatabaseTriggerLog_(database trigger)|ddlDatabaseTriggerLog]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | dbo.DatabaseLog
@@ Line 8: / Line 8: @@
 | '''Description
 | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | DatabaseLogID
@@ Line 76: / Line 74: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_DatabaseLog_DatabaseLogID
 | DatabaseLogID
@@ Line 88: / Line 86: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Insert
 | Database Trigger
-| [[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]
+| [[ddlDatabaseTriggerLog_(_(database_trigger))|ddlDatabaseTriggerLog]]
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for DatabaseLog records.<br />PK_DatabaseLog_DatabaseLogID
+| Primary key for DatabaseLog records.
 |- valign="top"
 | PostTime
@@ Line 31: / Line 32: @@
 | not null
+|
-| The date and time the DDL change occurred.<br />
+| The date and time the DDL change occurred.
 |- valign="top"
 | DatabaseUser
@@ Line 37: / Line 38: @@
 | not null
+|
-| The user who implemented the DDL change.<br />
+| The user who implemented the DDL change.
 |- valign="top"
 | Event
@@ Line 43: / Line 44: @@
 | not null
+|
-| The type of DDL statement that was executed.<br />
+| The type of DDL statement that was executed.
 |- valign="top"
 | Schema
@@ Line 49: / Line 50: @@
 | null
+|
-| The schema to which the changed object belongs.<br />
+| The schema to which the changed object belongs.
 |- valign="top"
 | Object
@@ Line 55: / Line 56: @@
 | null
+|
-| The object that was changed by the DDL statment.<br />
+| The object that was changed by the DDL statment.
 |- valign="top"
 | TSQL
@@ Line 61: / Line 62: @@
 | not null
+|
-| The exact Transact-SQL statement that was executed.<br />
+| The exact Transact-SQL statement that was executed.
 |- valign="top"
 | XmlEvent
@@ Line 67: / Line 68: @@
 | not null
+|
-| The raw XML data generated by database trigger.<br />
+| The raw XML data generated by database trigger.
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 84: / Line 94: @@
 |}

@@ Line 81: / Line 81: @@
 | Insert
 | Database Trigger
-| [[Database trigger to audit all of the DDL changes made to the AdventureWorks database._(database_trigger)|Database trigger to audit all of the DDL changes made to the AdventureWorks database.]]
+| [[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | dbo.DatabaseLog
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | DatabaseLogID
 | int
 | not null
+|
-| PK_DatabaseLog_DatabaseLogID
+| Primary key for DatabaseLog records.<br />PK_DatabaseLog_DatabaseLogID
+|- valign="top"
 | PostTime
 | datetime
 | not null
+|
+| The date and time the DDL change occurred.<br />
+|- valign="top"
 | DatabaseUser
 | sysname
 | not null
+|
+| The user who implemented the DDL change.<br />
+|- valign="top"
 | Event
 | sysname
 | not null
+|
+| The type of DDL statement that was executed.<br />
+|- valign="top"
 | Schema
 | sysname
 | null
+|
+| The schema to which the changed object belongs.<br />
+|- valign="top"
 | Object
 | sysname
 | null
+|
+| The object that was changed by the DDL statment.<br />
+|- valign="top"
 | TSQL
 | nvarchar(max)
 | not null
+|
+| The exact Transact-SQL statement that was executed.<br />
+|- valign="top"
 | XmlEvent
 | xml
 | not null
+|
+| The raw XML data generated by database trigger.<br />
+|}
 |}
 == automatically generated ==

@@ Line 159: / Line 159: @@
 | Insert
 | Database Trigger
-| [[ddlDatabaseTriggerLog_(database_trigger)|.ddlDatabaseTriggerLog]]
+| [[ddlDatabaseTriggerLog_(database_trigger)|false.ddlDatabaseTriggerLog]]
 |}

@@ Line 155: / Line 155: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[.ddlDatabaseTriggerLog_(database_trigger)|.ddlDatabaseTriggerLog]]