asked
SQLAzure
Hi All, Can you suggest me for the following issue in SQL Azure thn the Error is Identity / Primary Key field in SQL Azure skipping Like (i.e. increased every week 20000,30000,40000,50000 ).
It's normal for an identity column to have gaps. Can you be more specific on the error (is it an actual error for which you can include the error text, or is it just behavior that you aren't expecting)? Is it using an increment of 10,000? Is it skipping tens of thousands of numbers?
Thanks For Your Response Actually the error is i have created a table with identity level (1,1) First record inserted 1,2,3,4,5 ..... 1000 -----> First Week 10200,10201,10202 -----> Second Week 20100,20101,20102 ----->Third Week 33300,33301,33302 -----> Forth Week like that every week around 10000 seeds are increased,
I'm pretty sure that's related to [this Connect item][1], although I haven't seen it occur within any of my Azure databases. I'd suggest reporting this to Microsoft. [1]:
https://connect.microsoft.com/SQLServer/Feedback/Details/739013
16 People are following this question.
