problem when deleting record in table

I tried to delete all record in Table X
but sometimes it takes very long time and sometimes just like hang, the
status is
"Executing Query Batch"
why could this happen?HI,
Use
TRUNCATE TABLE <table name>
to delete all records in a table.
Thanks
Hari
SQL Server MVP
"chin_yen83" <chin_yen83@.yahoo.com> wrote in message
news:1124938782.400433.251690@.o13g2000cwo.googlegroups.com...
>I tried to delete all record in Table X
> but sometimes it takes very long time and sometimes just like hang, the
> status is
> "Executing Query Batch"
> why could this happen?
>