>
>That's correct... Truncate table is not loggable, as well as select ... into.
It's long standing myth that the truncate table is not logged. If it was the case, each TRUNCATE TABLE statement would break consistency of a transaction log. The TRUNCATE TABLE is a minimally-logged operation. Only deallocation of the extents are logged not the deletion of individual rows.
--sb--