Hi! Nice article so, thanks!

I have an interest though in DDL triggers in a security context with regards to accountability.

I am interested in a trigger that allows me to see whether someone has attempted to drop a database (a trigger exists to prevent the DROP being successful) or create one and at the information I would like to see is the name of the Windows user logged on, the name of the SQL Server user that is logged on and the event date. What I would also like to see is the name of the database this person has attempted to drop or even better, the TSQL that this person has attempted to execute.

Do you have any ideas....?

Regards to all!

Kev