thanks, but I still need to capture actual statement while deadlock occurred.

ok. that's good.

How do I capture deadlock with alert with any sql statement or any process and send e-mail to my e-mail address?

Basically, I want detail sql statement e-mail it...

Next question:

Should I use script like below (Query Analyzer ) or use SQL Server 7 Enterprise Manager and do table design option? Which one is faster?

CREATE CLUSTERED INDEX TblPartBit_CustomerID_IDX

ON TblPartBit...

In any case, I need to add clustered index as well as non-clustered index in sample large table.