hi,

I once had similar issue and i used a combination of database level triggers and Server level triggers.

Foe Database level it was for checking who and when data was deleted on a table, and for Server level it was for

who or when a table structure was modified.