Hi All,

Is there a way to prevent SQL identity value from incrementing when rollback transaction occurs in the stored procedure designed to insert a new record?

Thank you,
Daniel