Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

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

Print | posted on Thursday, October 21, 2004 6:07 PM | Filed Under [ SQL Server - General ]

Feedback

Gravatar

# re: Auditing DML in SQL Server 2005

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
Gravatar

# re: Auditing DML in SQL Server 2005

Oops, that's what I meant! I'll update it to reflect that.
10/22/2004 11:03 AM | Tara
Gravatar

# re: Auditing DDL in SQL Server 2005

Database level triggers...how cool...

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

10/22/2004 1:56 PM | Brett
Gravatar

# re: Auditing DDL in SQL Server 2005

I find it very useful in a development environment where developers aren't communicating with the DBAs.
10/22/2004 1:58 PM | Tara
Gravatar

# re: Auditing DDL in SQL Server 2005

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.

Powered by:
Powered By Subtext Powered By ASP.NET