dbo.DatabaseLog Table

Information

Name	DatabaseLog
Schema	dbo
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:33

Extended Properties

Name	Type	Property Name	Value
DatabaseLog	TABLE	MS_Description	Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.

Columns

Name	Data Type	Collation
DatabaseLogID	int
PostTime	datetime
DatabaseUser	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS
Event	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS
Schema	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS
Object	nvarchar(128)	SQL_Latin1_General_CP1_CI_AS
TSQL	nvarchar(max)	SQL_Latin1_General_CP1_CI_AS
XmlEvent	xml

Indexes

Name	Type	Primary	Unique	Columns
PK_DatabaseLog_DatabaseLogID	NonClustered			DatabaseLogID

SQL Script

CREATE TABLE [dbo].[DatabaseLog] (
    [DatabaseLogID] int NOT NULL IDENTITY,
    [PostTime] datetime NOT NULL,
    [DatabaseUser] nvarchar(128) NOT NULL,
    [Event] nvarchar(128) NOT NULL,
    [Schema] nvarchar(128) NULL,
    [Object] nvarchar(128) NULL,
    [TSQL] nvarchar(max) NOT NULL,
    [XmlEvent] xml NOT NULL
);