• As far as I know, there's no DDL trigger that can pickup a TRUNCATE, unfortunately. You'll find the list here:

    http://msdn.microsoft.com/en-us/library/bb522542(v=sql.105).aspx

    Now, as a workaround, you could create an instead of trigger and check the rowcount of deleted vs. the table and if they match, fire an event to your logging system.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA