ran from query analyzer DELETE FROM ....... it is supposed to delete like 80 million rows. the connection got broken with the below error: "ConnectionCheckForData"... "General Network Error." "Connection Broken". I looked in Current Processes and there is a process there. IF I click on this process its the same delete statement that I ran above. But the process is "sleeping" and has Open Transaction count of 2. There are like 1000 I/O's a second taking place there now. The command says "Killed/Rollback". I cannot kill this process. I need to. why is this rolling back?? (which i assume its doing). I just ran delete from...... what should i do here?? HELP!!!!