Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: dbo DatabaseLog (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:46


wikibot

Tabledbo.DatabaseLog
DescriptionAudit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

ColumnData TypeNullableDefaultDescription / PK / Index
DatabaseLogIDintnot null Primary key for DatabaseLog records.
PK_DatabaseLog_DatabaseLogID
PostTimedatetimenot null The date and time the DDL change occurred.
DatabaseUsersysnamenot null The user who implemented the DDL change.
Eventsysnamenot null The type of DDL statement that was executed.
Schemasysnamenull The schema to which the changed object belongs.
Objectsysnamenull The object that was changed by the DDL statment.
TSQLnvarchar(max)not null The exact Transact-SQL statement that was executed.
XmlEventxmlnot null The raw XML data generated by database trigger.



Reference TypeObject TypeReferencing Object
InsertDatabase TriggerddlDatabaseTriggerLog

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.