September 10, 2007 at 9:48 am
Hi Experts,
I am getting the following message when i close the query analyzer window every time. But my co-worker didn't get any messge what i mentioned.
----------------------------------------------------------------
There are Uncommitted Transaction.
Do you want to commit these transactions before closing the window ?
------------------------------------------------------------------
Inputs are welcome !
Regards
Karthik
karthik
September 10, 2007 at 1:02 pm
You've either specified a BEGIN TRANSACTION without doing a COMMIT/ROLLBACK, or you have SET IMPLICIT_TRANSACTIONS set to ON.
September 11, 2007 at 6:28 am
Thanks John.
I have executed SET IMPLICIT_TRANSACTION ON statement. It is executing fine.
Can you explain me the internal working structure of IMPLICIT_TRANSACTION ?
Regards
Karthik
karthik
September 11, 2007 at 7:13 am
Did you read about SET IMPLICIT_TRANSACTION in BOL? I think it is described pretty well there. If you don't understand something from it, then it would be best to ask more specific questions.
September 11, 2007 at 7:47 am
Yes, I second what Vladan posted. Read through BOL on not only that topic but on transactions in general and post any questions you come accross. The default behavior for Query Analyzer is SET IMPLICIT_TRANSACTIONS OFF so you may also want to check to see why you have it ON and make a decision as to how you want to operate.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply