Thread: 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

Are you talking of oracle my dear ???

i can't understand what you want to write pls explain

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.

it possible in SQL Server 2000 or 2005