Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

My identity values has jumped how to set it normal

Please can you someone help me in the steps in setting the identity value back

I have the table which has a identity column and it was good untill 2 days back and now suddenly the value has bumped up by 500000000 and giving its own values to the identity thing which should have ben sequential.

Please can some one give the steps to set it back

is it

1)bcp out the values

2)run sp_changeattribute tablenmae,"identity_burn_max", 0, "[new_value]"(new values some value bigger than the preseent row count)

3)then bcp in the values back

plz let me know if thats the solution

Its an urjently required

version is 15.7 and non prod environment.


Former Member
Not what you were looking for? View more on this topic or Ask a question