After 24hours, I "killed" a DTS task that never finished,
probably due to a bad index. By killed, I hit cancel on
the DTS status window and after another two hours of
waiting I opened Task Manager and Ended the process.

Now I can't even get into any databases on that server! I
tryed stopping the server, rebooting, but alas, when ever
I get into Entrprise Manager and try to open databses, it
just locks up.

Any help would be greatly appreciated.

Thanks

Hi,
Whenever you kill a process it tries to roll back the transaction. In
your case you have killed the DTS process which ran for more than 24
Hrs. when you do that it tries to rollback the whole transaction, which
means it will take another 24 Hrs. to do that. Nprmally when you come
across this king of situations it is recommended that you let the
transaction to complete rather than killing it.

The problem which you have right now is when you stop and start the
server, the server will still try to recover the complete process. so
let it run and I hope it will solve the problem.

Chak



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

To add to Chak's comment

If you go to QA and issue sp_who2 you will probably see a ROLLBACK event
happening. 24 hours going forward is on my opinion >24hrs to wind it back.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Chak G" <iswellendswell (AT) hotmail (DOT) com> wrote

Try to make your transaction in DTS smaller. This is the lesson I got from an experience like yours. Just wait until the rollback finishes.