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
Legacy Comments
|
mkbosmans
2004-10-22 |
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. |
|
Tara
2004-10-22 |
re: Auditing DML in SQL Server 2005 Oops, that's what I meant! I'll update it to reflect that. |
|
Brett
2004-10-22 |
re: Auditing DDL in SQL Server 2005 Database level triggers...how cool... I wonder what warped stuff we could come up with.... |
|
Tara
2004-10-22 |
re: Auditing DDL in SQL Server 2005 I find it very useful in a development environment where developers aren't communicating with the DBAs. |
|
robvolk
2004-10-22 |
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. :) |