January 9, 2011 at 11:36 pm
when i tried to execute chained state of stored procedures.
system encountered exception error no:266
with following message.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 2, current count = 0.
can anyone help me !!!!!
Thanks in advance!!!!
January 10, 2011 at 7:05 am
hemanth T (1/9/2011)
when i tried to execute chained state of stored procedures.system encountered exception error no:266
with following message.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 2, current count = 0.
can anyone help me !!!!!
Thanks in advance!!!!
Sound like you have BEGIN TRANSACTION in the code and no COMMIT or ROLLBACK as the error message says. Do you have IF statements that might redirect the execution away from the COMMIT? Do you have a catch block for errors that doesn't have a ROLLBACK? These are the kinds of things you have to look for.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply