Home Forums SQL Server 2005 T-SQL (SS2K5) DDL Trigger to prevent dropping of a specific table? RE: DDL Trigger to prevent dropping of a specific table?

  • OK, so know I have a DDL trigger that logs all events, a DDL trigger to prevent this specific table from being dropped, and a normal table trigger to prevent the deletion or updates of records from this table.

    I can't think of any other action a user can do to the table other then Truncating it. Is there a way to prevent Truncating a table? Won't truncating override any triggers on the table?