Check out this website I found at connect.microsoft.com
It is late admittedly and I am just skim reading at the moment but unless I am very much mistaken SCOPE_IDENTITY and @@IDENTITY which are the inbuilt SQL Server functions for returning the newly inserted unique identifier are broken in SQL Server 2005 and SQL Server 2008.
Not good. Time to re-read this and have a rummage about on google.
No comments:
Post a Comment