• lsrep17 Documentation
    • Tables [dbo].[DatabaseLog]
    expanded
    MS_Description
    Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
    expanded
    Properties
    PropertyValue
    CollationSQL_Latin1_General_CP1_CI_AS
    HeapTrue
    Row Count (~)1597
    Created13:14:18 14 marca 2012
    Last Modified13:14:41 14 marca 2012
    expanded
    Columns
    KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDescription
    Primary Key PK_DatabaseLog_DatabaseLogID: DatabaseLogIDDatabaseLogIDint4
    False
    		1 - 1Primary key for DatabaseLog records.
    PostTimedatetime8
    False
    		The date and time the DDL change occurred.
    DatabaseUser[sys].[sysname]256
    False
    		The user who implemented the DDL change.
    Event[sys].[sysname]256
    False
    		The type of DDL statement that was executed.
    Schema[sys].[sysname]256
    True
    		The schema to which the changed object belongs.
    Object[sys].[sysname]256
    True
    		The object that was changed by the DDL statment.
    TSQLnvarchar(max)max
    False
    		The exact Transact-SQL statement that was executed.
    XmlEventxmlmax
    False
    		The raw XML data generated by database trigger.
    expanded
    Indexes
    KeyNameKey ColumnsUniqueDescription
    Primary Key PK_DatabaseLog_DatabaseLogID: DatabaseLogIDPK_DatabaseLog_DatabaseLogIDDatabaseLogID
    True
    		Primary key (nonclustered) constraint
    expanded
    SQL Script
    CREATE TABLE [dbo].[DatabaseLog]
    (
    [DatabaseLogID] [int] NOT NULL IDENTITY(1, 1),
    [PostTime] [datetime] NOT NULL,
    [DatabaseUser] [sys].[sysname] NOT NULL,
    [Event] [sys].[sysname] NOT NULL,
    [Schema] [sys].[sysname] NULL,
    [Object] [sys].[sysname] NULL,
    [TSQL] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [XmlEvent] [xml] NOT NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[DatabaseLog] ADD CONSTRAINT [PK_DatabaseLog_DatabaseLogID] PRIMARY KEY NONCLUSTERED  ([DatabaseLogID]) ON [PRIMARY]
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', NULL, NULL
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key for DatabaseLog records.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'DatabaseLogID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The user who implemented the DDL change.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'DatabaseUser'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The type of DDL statement that was executed.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Event'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The object that was changed by the DDL statment.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Object'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The date and time the DDL change occurred.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'PostTime'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The schema to which the changed object belongs.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'Schema'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The exact Transact-SQL statement that was executed.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'TSQL'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'The raw XML data generated by database trigger.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'COLUMN', N'XmlEvent'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Primary key (nonclustered) constraint', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'CONSTRAINT', N'PK_DatabaseLog_DatabaseLogID'
    GO
    EXEC sp_addextendedproperty N'MS_Description', N'Nonclustered index created by a primary key constraint.', 'SCHEMA', N'dbo', 'TABLE', N'DatabaseLog', 'INDEX', N'PK_DatabaseLog_DatabaseLogID'
    GO