Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on a table and when you Rollback your transaction then identity value that is inserted to the table is not rolled back. Let me demo you on this scenario using an example. First we will create… Continue reading SQL Server – Change in Identity() Property during transactions