using truncate table

04-21-08, 08:11 AM

Roy Goldhammer

Hello there

When i use Truncate instead of delete the data from table which deleted is
not saved to log file.

However, if i run truncate inside of transaction and rollback the
transaction. the data is comming back. if no log is being written in
truncate how it bring back the data by rolling back the transaction?

04-21-08, 08:53 AM

Zarko Jovanovic

Roy Goldhammer wrote:
> Hello there
>
> When i use Truncate instead of delete the data from table which deleted is
> not saved to log file.
>
> However, if i run truncate inside of transaction and rollback the
> transaction. the data is comming back. if no log is being written in
> truncate how it bring back the data by rolling back the transaction?
>truncate is *minimaly* logged, that doesn't mean it isn't :-)

http://techahead.wordpress.com/2007/...te-and-delete/

Similar Threads
Thread	Thread Starter
Grant permission to table for truncate table hi, we have object-level user security. That user need permission for truncate one table. I can't set the user as sysadmin or DBO. any way that I could grant the user to have...	mecn
Truncate a table in use? Can this be done in SQL? Every 30 seconds, 400K recs are imported to a table. At the end of 30 secs, the 400K recs are deleted and another 400K recs are imported. This needs...	donsql22222
Truncate table I'm trying to use a table type variable in my stored procedure: DECLARE @Temp3 table ( RecordID int IDENTITY (1, 1) Primary key NOT NULL , FAccountID int, [Name]...	vovan
Can't Truncate table I don't get this. I have foreign keys set up on a table, which I disabled via: ALTER TABLE <MyTable> NOCHECK CONSTRAINT ALL When I view the results of EXEC...	John
Truncate table in DTS I have an Execute SQL Task in DTS that runs a simple trucate table command. If I run it by executing only the single step in the DTS designer, it completes very quick, about...	Phil Kay