This article is a journey to understanding an exception raised when attempting to set IDENTITY_INSERT on in two nested stored procedures.  It hinges on the misinterpretation of an exception message, and the discussion veers into temporary-table-caching. The explanation, as always, … Continue reading →