The first & second SP's both return a Scope_Identity() value for the record
that the SP Inserts.
However, I ignore the first one, but need to act on the second one. If I
ignored the returned value from the second recordset, I could continue to
use the original connection.
I understand what you mean about the connection potentially being occuped,
but I'm unclear as to how you think I should check this.
"[MSFT]" <lukezhanonline.microsoft.com> wrote in message
> Hi Chris,
> From another post, I know you have temporarily get around this problem by