Trigger should not impact SCOPE_IDENTITY, did the record get inserted into C?