http://dbshelp.devio.at/index.php?action=history&feed=atom&title=DdlDatabaseTriggerLogdatabase_trigger 2026-05-28T08:12:27Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=DdlDatabaseTriggerLogdatabase_trigger&diff=2531&oldid=prev 2010-06-23T22:07:13Z

<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;Database Trigger | ddlDatabaseTriggerLog |- valign=&quot;top&quot; | &#039;&#039;&#039;Description...</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 /> | '''Database Trigger<br /> | ddlDatabaseTriggerLog<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Database trigger to audit all of the DDL changes made to the AdventureWorks database.<br /> |}<br /> <br /> === Source ===<br /> &lt;pre&gt;<br /> CREATE TRIGGER [ddlDatabaseTriggerLog] ON DATABASE <br /> FOR DDL_DATABASE_LEVEL_EVENTS AS <br /> BEGIN<br /> SET NOCOUNT ON;<br /> <br /> DECLARE @data XML;<br /> DECLARE @schema sysname;<br /> DECLARE @object sysname;<br /> DECLARE @eventType sysname;<br /> <br /> SET @data = EVENTDATA();<br /> SET @eventType = @data.value('(/EVENT_INSTANCE/EventType)[1]', 'sysname');<br /> SET @schema = @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname');<br /> SET @object = @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'sysname') <br /> <br /> IF @object IS NOT NULL<br /> PRINT ' ' + @eventType + ' - ' + @schema + '.' + @object;<br /> ELSE<br /> PRINT ' ' + @eventType + ' - ' + @schema;<br /> <br /> IF @eventType IS NULL<br /> PRINT CONVERT(nvarchar(max), @data);<br /> <br /> INSERT [dbo].[DatabaseLog] <br /> (<br /> [PostTime], <br /> [DatabaseUser], <br /> [Event], <br /> [Schema], <br /> [Object], <br /> [TSQL], <br /> [XmlEvent]<br /> ) <br /> VALUES <br /> (<br /> GETDATE(), <br /> CONVERT(sysname, CURRENT_USER), <br /> @eventType, <br /> CONVERT(sysname, @schema), <br /> CONVERT(sysname, @object), <br /> @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(max)'), <br /> @data<br /> );<br /> END;<br /> &lt;/pre&gt;<br /> <br /> === References ===<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 /> | '''Dependency Type<br /> | '''Object Type<br /> | '''Referenced Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Insert<br /> | Table<br /> | [[dbo.DatabaseLog_(table)|dbo.DatabaseLog]]<br /> <br /> |}</div>

Bot