SCOPE_IDENTITY vs. @@IDENTITY vs. IDENT_CURRENT in SQL Server 2008 | Glenn Berry's SQL Server Perfor

I have seen several SQL MVP bloggers posting about an open bug in Microsoft Connect where SCOPE_IDENTITY does not always return the correct result when query parallelism is involved with SQL Server 2005 or SQL Server 2008. SCOPE_IDENTITY ...

sqlserverperformance.wordpress