Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing.

Question

I am getting this sql server exception when I execute my data layer.
but my data set does not have any exception. it was an existing code and it was working fine so far. I am not able to find out the problem.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0

any help?

Thanks

Answer 1

It looks to me that there is some problem with your query. Start the SQL Profiler get the corresponding query and execute it that in the sql server management studio.

Now check the exception in the management studio. Check the message tab where you can see the exact problem with your query. if you fix this problem then your exception will be resolved.

Hope this helps.