After a discussion with a colleague, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a look at the IDENT_CURRENT() function, and demonstrates how it cannot be relied upon for reporting the IDENTITY value that was generated – even under the SERIALIZABLE isolation level.