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	08/01/2010 08:40
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	1566
Data Space Used	6,264.00 KB
Index Space Used	48.00 KB

Columns

Column Name	Description	Datatype	Length
DatabaseLogID	Primary key for DatabaseLog records.	int	4
PostTime	The date and time the DDL change occurred.	datetime	4
DatabaseUser	The user who implemented the DDL change.	sysname	128
Event	The type of DDL statement that was executed.	sysname	128
Schema	The schema to which the changed object belongs.	sysname	128
Object	The object that was changed by the DDL statment.	sysname	128
TSQL	The exact Transact-SQL statement that was executed.	nvarchar	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]

Related Objects

dbo Schema
AdventureWorks Database