DBCC Dbreindex ...

What happens when I try to cancel out of a DBCC DBreindex on a table ? It
was going on for 5 hours and I decided to cancel it.. It took 2-3 minutes to
cancel.
My question is has it done some work atleast ? When I cancel it like how I
have, what does it do .. obviously not a rollback cos it took just 2-3
minutes and luckily not 5 hours or more
Please let me know...Yes, it does a rollback. however, the rollback is fast as the old index is still there, so all SQL
Server has to do is to deallocate whatever is has managed to build so far.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:%23FPANCTxDHA.2064@.TK2MSFTNGP10.phx.gbl...
> What happens when I try to cancel out of a DBCC DBreindex on a table ? It
> was going on for 5 hours and I decided to cancel it.. It took 2-3 minutes to
> cancel.
> My question is has it done some work atleast ? When I cancel it like how I
> have, what does it do .. obviously not a rollback cos it took just 2-3
> minutes and luckily not 5 hours or more
> Please let me know...
>