dbo.DatabaseLog Table

Description

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

Properties

Creation Date	17/07/2014 16:11
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	1597
Data Space Used	6,544.00 KB
Index Space Used	56.00 KB

Columns

Column Name	Description	Datatype	Length
DatabaseLogID	Primary key for DatabaseLog records.	Integer	4
PostTime	The date and time the DDL change occurred.	DBTimeStamp	4
DatabaseUser	The user who implemented the DDL change.	VarWChar	128
Event	The type of DDL statement that was executed.	VarWChar	128
Schema	The schema to which the changed object belongs.	VarWChar	128
Object	The object that was changed by the DDL statment.	VarWChar	128
TSQL	The exact Transact-SQL statement that was executed.	LongVarWChar	16
XmlEvent	The raw XML data generated by database trigger.	Xml	16

Indexes

Index	Description	Primary	Unique
PK_DatabaseLog_DatabaseLogID	Primary key (nonclustered) constraint

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[DatabaseLog](
    [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL,
    [PostTime] [datetime] NOT NULL,
    [DatabaseUser] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Event] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [Schema] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Object] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [TSQL] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [XmlEvent] [xml] NOT NULL,
 CONSTRAINT [PK_DatabaseLog_DatabaseLogID] PRIMARY KEY NONCLUSTERED 
(
    [DatabaseLogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Related Objects

dbo Schema
AdventureWorks Database