I migrate my db from oracle to sql server using ssma for oracle.
after migration, i still use nextval function that created by ssma.
the problem is, the function is not consistent.
Sometimes, it produce values, but in other times it produce null.
The strange part is, the sequence between last number and after null number is still on sequence, example:
1st call >> 1
2nd call >> 2
3rd call >> NULL
4th call >> NULL
5th call >> 5
can you explain how to fix this problem?
thank you verymuch
View Complete Post