Hello.

I am reconnecting second session you mentioned. One, which executes
INSERT, stays connected.

Also, I am not sure, if idea about commits is entirely right. Fact is,
that from first session I launch stored procedure, which, in turn calls
for other stored procedure, it performs designed actions, executes
commit and returns to "main" procedure, which I called from ISQL.

Idea is, that process performs many commits, while I do not see any
changes from second session as long as I do not reconnect it.


Cal

Dhannya wrote:
> Just wondering if you had disconnected & then connected the first
> (where INSERT is being executed) or second (where you are monitoring
> the count) ISQL session. If it is first, I think the suggestion on
> uncommitted transactions would be the perfect answer. Kindly clarify as
> to which session you had reconnected.