I have identity column in TD table. It starts with 1. Then for 2nd run it starts with 10001. Then on 3rd run it starts with 2. Is Identity column not reliable in TD?
is there any reason.....
It is reliable to the design. It will assign unique values but not is sequence.
Read the manual carefully and be aware of side effects on copy of data etc.
you might find some answers in