keyongtech


  keyongtech > sqlserver.* > sqlserver.programming > 04/2008

 #1  
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?
 #2  
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
Truncate Table...

Hi All, Just made a really silly mistake, I was using EMS MS SQL Manager and was looking for a way to truncate logs, to save some space on the server... foolishly I couldn't...

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...

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...

Truncate table

Hi I want to truncate all data in database ... pls help me how i ll truncate?

Truncate table

Hello there, I want to truncate a table through a stored procedure. A user say Dev_Staff only has db_datareader, db_datawriter and EXEC role (Customised) to execute all the...


All times are GMT. The time now is 04:56 AM. | Privacy Policy