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

0 votes
asked Aug 9, 2014 in SQL Server by Priya Roy (122 points)

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

Share

1 Answer

+1 vote
answered Aug 9, 2014 by Kannan Chandrasekara (112 points)
selected Aug 10, 2014 by Priya Roy
 
Best answer

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.

Your answer

Preview

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.
site design / logo / content © 2013 - 2015 pinfaq.com
...