For the last time, NO, you cannot trust IDENT_CURRENT()

After a discussion with a colleague, I take a look at the IDENT_CURRENT() function, and demonstrate how it cannot be relied upon for reporting the IDENTITY value that was generated, even under SERIALIZABLE.