Viewing 2 posts - 1 through 2 (of 2 total)
Try to use scope_identity() instead of @@IDENTITY. scope_identity() is session wide. @@IDENTITY is global and it may be source of your problems.
November 11, 2011 at 12:11 pm
#1406546
Why the article is titled "Relational Database Design" while it presents bunch of DDL&DML statements and shows implementation rather than design?
November 9, 2011 at 12:04 pm
#1405421