My problem is when serverside cursor and ado is used, implicit transactions are switched on automatically sometimes for whatever reason. is there anyway to ensure that every single sql statement in the stored proc continues to autocommit?
thanks a million Max
Mon, 14 Jun 2004 14:34:57 GMT
Rene Balver #2 / 2
Implicit roll back when using server side cursor
Quote:
> My problem is when serverside cursor and ado is used, > implicit transactions are switched on automatically > sometimes for whatever reason. is there anyway to ensure > that every single sql statement in the stored proc > continues to autocommit?
There is some problem with serverside cursors and transactions. My open serverside cursors are in a zombie state whenever I use a transaction. Maybe there you can find your problem.
Implicit roll back when using server side cursor