> Hi
>
> Check that @@Identity is not used in the SP to retrieve the Identity
value.
> SCOPE_IDENTITY must be used as it is not affected by triggers.
>
> Regards
> Mike
>
> "Günther Rühmann" wrote:
>
> >
> > Hello,
> >
> > i habe some trouble with a sql 2000 appclication
> > The envisonment:
> > SQL-2000 - Server MS Access2000 - Client that uses SQL server tables via
> > ODBC.
> >
> > After inserting a row to a table table_1 an insert trigger is running
that
> > inserts some fields of this row to a second table tabel_2.
> > The MS Access client show use the primary key of the first insert in
table_1
> > to add it to a new record in a detail table table_3.
> >
> > The problem is: instead of insertig the primary key of detail table
table_1
> > the primary key of table_3 (that has been inserted by the trigger on
> > table_1) is used.
> >
> > The problem seems only to occur in multi user mode.
> >
> > Anyone any idea ?
> >
> >
> >