FYI, there is a known bug with SCOPE_IDENTITY(): https://connect.microsoft.com

Dec 14, 2005 . Bug #15728, LAST_INSERT_ID function inside a stored function returns .

This article is very serious and I would like to explain this as simple as I can.

If you are sure you have a bug, try to create a small test to reproduce the problem

SCOPE_IDENTITY and @@IDENTITY return the last identity values that are

The scenario with adding SELECT SCOPE_IDENTITY after INSERT works. . .. I

there are known bugs with SCOPE_IDENTITY() in sql server 2005, not sure

Mar 21, 2009 . The bug is closed as fixed in SQL Server 2008, however the user . . The @@

Difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT(

http://blog.sqlauthority.com/2009/03/24/sql-server-2008-scope_identity-bug-with-

The following article on Microsoft Connect describes a bug in Scope_Identity(),

SCOPE_IDENTITY() which is commonly used in place of @@Identity has bug

Nov 19, 2009 . Can I use multiple SCOPE_IDENTITY() in the same stored procedure . SQL

Feb 8, 2010 . Is there a way for PowerBuilder to globally use scope_identity() . @@IDENTITY

http://blog.sqlauthority.com/2009/03/24/sql-server-2008-scope_identity-bug-with-

Aug 27, 2011 . I recently came across this post by Sebastian Meine talking about an issue with

Dec 7, 2011 . Yes, it's a bug - whenever a parallel query plan is generated @@IDENTITY and

Mar 24, 2009 . SCOPE_IDENTITY() which is commonly used in place of @@Identity has bug

I created a test SP yesterday wich returned SCOPE_IDENTITY() and it . . be a

May 6, 2011 . However, there is a nasty bug in SQL Server affecting SCOPE_IDENTITY()

SQL Server SCOPE_IDENTITY() has a bug. tonywr at tpg.com.au tonywr at tpg.

Mar 24, 2009 . SQL SERVER - 2008 - SCOPE_IDENTITY Bug with Multi Processor Parallel Plan

Feb 10, 2011 . SCOPE_IDENTITY sometimes returns the wrong value according to this . the

"SELECT @Lastest_id = SCOPE_IDENTITY()" which value i will . . way in Denali.

T-SQL: @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods . . Note

MS Sql quries with SCOPE_IDENTITY() does not produce expected results · Log

The bug is listed here in connect site SCOPE_IDENTITY() [. ]. Did you know that

Subject: [BUG] MSSQL Query "SELECT SCOPE_IDENTITY()" is not support in

Synonyms and SCOPE_IDENTITY(). Asked By Noe. 05-Feb-09 05:33 PM. Reply.

Mar 25, 2009 . [nhusers] Re: SCOPE_IDENTITY() sometimes returns incorrect . -2008-

Jan 29, 2011 . BUG with SCOPE_IDENTITY () Function in SQL Server. Recently in one of my

Mar 24, 2009 . Here is a couple of workarounds for the bug: . /03/24/sql-server-2008-

Feb 5, 2009 . The difference between @@IDENTITY and SCOPE_IDENTITY() is . A few years

Journey to SQL Authority with Pinal Dave This article is very serious and I would

. Dr. Altobelli for removing thorn from paw NHibernate: INSERT INTO Pet (

Feb 11, 2010 . http://blog.sqlauthority.com/2009/03/24/sql-server-2008-scope_identity-bug-with-

Mar 25, 2007 . on March 24, 2009 at 7:02 am | Reply · SQL SERVER - 2008 - SCOPE_IDENTITY

May 20, 2008 . is returned. Is this a bug or by design ? Is there any change that the system can

May 20, 2008 . It's sent in a separate batch, and MSSQL's SCOPE_IDENTITY() only works at the

The fix using OUTPUT has been applied. Al adds, incidentally our competitor

Possible bug with SCOPE_IDENTITY()? Search SQL Server Database Engine

Mar 9, 2011 . Paged: It was throwing invalid statement exceptions because the statement

Jul 16, 2009 . You may be interested in this confirmed bug where SCOPE_IDENTITY() returns

Aug 22, 2010 . Difference between SQL @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT

Mar 24, 2009 . I have seen several SQL MVP bloggers posting about an open bug in Microsoft

May 6, 2011 . Social Tagging: @@IDENTITY • bug • INSERT • OUTPUT • SCOPE_IDENTITY() •

Gavin King added a comment - 28/Apr/04 9:45 PM This is certainly NOT a "

Mar 19, 2009 . Apparently there is a bug in SQL Server 2005/2008 with Scope_Identity() related

Nov 10, 2009 . When a parallel plan is executed SCOPE_IDENTITY or IDENTITY may produce

Community Content. Example of IDENTITY incremented . Here is a clear cut

Sitemap