Truncate and Drop table Statement are getting RollBack
Hi To all
I want a clear answer
Delete can be rolled back and Truncate Cant Rollback
But Truncate getting Rollbacked
Not only Truncate ......Drop table Statement also getting RollBack
Try with this Sample Table and clarify my doubt
---------------------------------------------------------------
create table I (i int)
insert into I(i) values (1)
go
set nocount on
select i 'BEforeTruncate' from I
begin tran
truncate table I/Drop table I
select i 'afterTruncateBeforeRollback' from I
rollback
select i 'AfterTruncate' from I
results:
BEforeTruncate
1
afterTruncateBeforeRollback
AfterTruncate
-
1
Note that after the rollback, the table again has the row
Re: Truncate and Drop table Statement are getting RollBack
Are you talking of oracle my dear ???
Re: Truncate and Drop table Statement are getting RollBack
i can't understand what you want to write pls explain
Re: Truncate and Drop table Statement are getting RollBack
if you are talking oracle, then there is no way you can ROLLBACK a truncate stt.
Truncate is a DDL and it resets the HWM for the table.
Re: Truncate and Drop table Statement are getting RollBack
it possible in SQL Server 2000 or 2005