This article is very serious and I would like to explain this as simple as I can. SCOPE_IDNETITY() which is commonly used in place of @@Idnetity has bug when run in Parallel Plan. Do your community service. Read the article. Bookmark it. Kick it and spread the word.