On 30 Jan 2006, kasis_100@yahoo.com wrote:
> 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.

What is incorrect?

> 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.

Okay,

In your original post, you didn't clearly state what was going on. And,
at this point, it still isn't clear, but at least I know commits are
going somewhere in the executing process, which was my third suggestion.

Any chance you could post the executing code and the testing "select
count(*)" you are executing? Without it, I and others will be grasping
at all sorts of straws.

--
Galen Boyer