New answers tagged


SET IDENTITY_INSERT is just a session option allowing you to insert identity values explicitly in a subsequent statement. It doesn't do anything to the transaction log. I presume your first transaction wasn't actually committed and now is rolling back. This could happen if you have implicit_transactions on Or a possibly more likely scenario is that you ...

Top 50 recent answers are included