SQL Server rollback behaviour after incrementing a counter