Ramblings of a DBA

Tara Kizer

posts - 165, comments - 832, trackbacks - 75

Search this Blog

Auditing DDL in SQL Server 2005

Benjamin Jones shows us an example of using extended triggers to capture DDL statements. Very cool!

For those of you wondering...DDL - data definition language - examples: CREATE/ALTER/DROP TABLE, CREATE/DROP INDEX

His trigger actually catches DDL statements.

The type of triggers that act on DML statements were implemented before SQL Server 2005 I think.

10/22/2004 11:00 AM | mkbosmans

Oops, that's what I meant! I'll update it to reflect that.

10/22/2004 11:03 AM | Tara

Database level triggers...how cool...

I wonder what warped stuff we could come up with....

10/22/2004 1:56 PM | Brett

I find it very useful in a development environment where developers aren't communicating with the DBAs.

10/22/2004 1:58 PM | Tara

I find revoking and denying permissions to be very useful for developers who don't communicate with the DBA. :)

10/22/2004 3:25 PM | robvolk

Comments have been closed on this topic.