General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>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.
"minimally-logged operation" Ok Segey! :) :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only