January 23rd, 2014
No, you can't trust IDENT_CURRENT

I demonstrate how IDENT_CURRENT cannot be relied upon for reporting your new IDENTITY value, even under SERIALIZABLE.