> > wrong. It's the last identity value used by that connection.
>
> i was previously told on this list that @@IDENTITY is per connection per
> table.
no, its per connection. if you insert a table that has a trigger that fires
an insert into another table w/identity, then @@IDENTITY will contain
the 2nd table's value. in these cases its easy enough to re-write the
triggers to grab the 1st @@IDENTITY & hold it in a local var
to send back to the caller.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
