|
|
||||||
|
#1
04-21-08, 08:11 AM
|
|
|
|
|
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
|
|
|
|
|
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
|
using truncate table