Hi, i am facing 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.
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
[ + ] Show comment
-
By SP do you mean service pack? You need to provide more detailed information in order to make your issue more understandable. - EdT 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
