Curious about this one, wouldn't the second SET IDENTITY_INSERT ON statement generate an error right there?

"If a table already has this property set to ON, and a SET IDENTITY_INSERT ON...