Thanks

I am going this route, luckily I do not need to use triggers on the table.

Steve

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns961380405DD2Yazorman@127.0.0.1...
> Steve (stevej@ufrmsa1.uniforum.org.za) writes:
> > SCOPE_IDENTITY is not supported by SQL Server 7 (once again I am sorry I
> > forgot to mention which version of
> > SQL Server I am using) do you have any other suggestions ?
>
> Use @@identity instead. If you have a trigger on the table that inserts
> into a secont identity table, @@identity will have the value from that
> table. This is why scope_identity() is usually recommended, since it
> returns the most recently used identity value in the current scope.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp