question

Sakthivel avatar image
Sakthivel 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 ).
sql-server-2012sql-azure
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
0 Likes 0 ·
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,
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.