See IDENTITY and SCOPE_IDENTITY( ) in SQL Server Books Online.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
"James Hall" <halljhdshs.wa.gov> wrote in message
I am working on a multiple table insert. My master table
has an id field that is an identity field. Before writing
records to the related tables, I need to find out what the
id is that was just created. I seem to remember being able
to get to it by accessing a system cache - probably
tempdb. I can't find my example - anybody know how ...