Viewing 2 posts - 1 through 2 (of 2 total)
OK, that's good information regarding the bug affecting @@IDENTITY and SCOPE_IDENTITY(). According to the article you provided, the bug is fixed in 2008 R2 SP 1 and above. ...
March 26, 2013 at 4:19 pm
#1600976
I came to add exactly the same point - SCOPE_IDENTITY() would guarantee that the just-inserted rows' newly-generated IDENTITY value would be unique.
March 26, 2013 at 2:00 pm
#1600955