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
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.