http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.DatabaseLogtable 2026-06-13T02:41:08Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.DatabaseLogtable&diff=2539&oldid=prev 2010-06-23T22:07:24Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Table | dbo.DatabaseLog |- valign=&quot;top&quot; | &#039;&#039;&#039;Description | Audit table tr...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Table<br /> | dbo.DatabaseLog<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.<br /> |}<br /> <br /> === Columns ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Column<br /> | '''Data Type<br /> | '''Nullable<br /> | '''Default<br /> | '''Description<br /> <br /> |- valign=&quot;top&quot;<br /> | DatabaseLogID<br /> | int<br /> | not null<br /> | <br /> | Primary key for DatabaseLog records.<br /> |- valign=&quot;top&quot;<br /> | PostTime<br /> | datetime<br /> | not null<br /> | <br /> | The date and time the DDL change occurred.<br /> |- valign=&quot;top&quot;<br /> | DatabaseUser<br /> | sysname<br /> | not null<br /> | <br /> | The user who implemented the DDL change.<br /> |- valign=&quot;top&quot;<br /> | Event<br /> | sysname<br /> | not null<br /> | <br /> | The type of DDL statement that was executed.<br /> |- valign=&quot;top&quot;<br /> | Schema<br /> | sysname<br /> | null<br /> | <br /> | The schema to which the changed object belongs.<br /> |- valign=&quot;top&quot;<br /> | Object<br /> | sysname<br /> | null<br /> | <br /> | The object that was changed by the DDL statment.<br /> |- valign=&quot;top&quot;<br /> | TSQL<br /> | nvarchar(max)<br /> | not null<br /> | <br /> | The exact Transact-SQL statement that was executed.<br /> |- valign=&quot;top&quot;<br /> | XmlEvent<br /> | xml<br /> | not null<br /> | <br /> | The raw XML data generated by database trigger.<br /> |}<br /> <br /> === Primary Key ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Primary Key<br /> | '''Columns<br /> |- valign=&quot;top&quot;<br /> | PK_DatabaseLog_DatabaseLogID<br /> | DatabaseLogID<br /> |}<br /> <br /> === Dependencies ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Reference Type<br /> | '''Object Type<br /> | '''Referencing Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Insert<br /> | Database Trigger<br /> | [[ddlDatabaseTriggerLog_(database trigger)|ddlDatabaseTriggerLog]]<br /> <br /> |}</div>

Bot