I have written a sp which will do insert update delete operations on different tables. it is taking an xml and some other inputs and performing action. I am facing a problem here. when i take all inputs and running that sp in db it wont throw any error and runs smoothly. But when i do it from data access from code it is throwing following error

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

but i am not using any transaction in my sp.

Please help me its very urgent.!!!!

Thanks in advance.

1 Comment   [ - ] Hide Comment


  • By SP do you mean service pack? You need to provide more detailed information in order to make your issue more understandable.
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity