Hi,

I had this problem too, after migrating an application from sql server 2000 to sql server 2005. I am working with .Net 2005, Framework 2.0 .

I fixed it by changing the code that caused the error. I had a single Connection executing two commands (procedures) on the same method. I was only closing the Connection after the second command, and it didn't cause problems in sql 2000. But for some reason it caused this error on 2005:

The server failed to resume the transaction. (...)

I only created another connection, and each connection executes now only one command. Worked for me.

Hope it helps,

Best regards,

Edu