Hmm... Make of this what you will !
From Sybase SQL Server™ Transact-SQL® User’s Guide
Rules Associated with Triggers:
You cannot create a trigger on a view or on a temporary table,
though triggers can reference views or temporary tables.
Although a truncate table statement is, in effect, like a delete without
a where clause because it removes all rows, it cannot fire a
trigger because individual row deletions are not logged.
Some commands that change the database are not logged, such as
truncate table, bulk copy into a table that has no indexes, select into,
writetext and dump transaction with no_log.
Use truncate table as a fast method of deleting all the rows in a table. It’s
almost always faster than a delete statement with no conditions,
because the delete logs each change, while truncate table just logs the
deallocation of whole data pages. truncate table immediately frees all
the space that the table’s data and indexes had occupied. The freed
space can then be used by any object.
And...... from Adaptive Server® Anywhere SQL Reference Manual
The TRUNCATE TABLE statement is entered into the transaction log as a
single statement, like data definition statements. Each deleted row is not
entered into the transaction log.
HTH
;-) Dickie Bird
db@dickiebird.freeserve.co.uk
