Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
Hello everyone. There's any turn around to avoid this "problem" with sql server 2012? I have just three customers on my table(excluding the guest customers) and the Id it's already on "2228". I read that if we create Sequences with "No Cache" we can avoid this problem. Some guys already create scenarios explain the problem http://www.dailymotion.com/video/xrkus9_bug-sequence-breaks-gap-numbers-after-restart-sql-server_school http://www.big.info/2013/01/how-to-solve-sql-server-2012-identity.html But in a nopcommerce way how could i avoid this?
Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
No one else have this problem???? http://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is http://connect.microsoft.com/SQLServer/feedback/details/743300/identity-column-jumps-by-seed-value#tabs http://www.sqlserver-training.com/sequence-breaks-gap-in-numbers-after-restart-sql-server-gap-between-numbers-after-restarting-server/-
Tổng Bài đăng:
11362
Karma:
101242
Đã tham gia:
22/05/2011
Vị trí:
United States
It would seem that using a Sequence instead of Identity is the only workaround at this time; https://connect.microsoft.com/SQLServer/feedback/details/739013/failover-or-restart-results-in-reseed-of-identity CREATE SEQUENCE s1 AS INT START WITH 1 NO CACHE; CREATE TABLE t1 (Id INT PRIMARY KEY DEFAULT NEXT VALUE FOR s1, col INT NOT NULL);
Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
So now, using nopcommerce with SQL Server 2012, we must create sequences to entire tables to avoid this weird gap between the Ids?
Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
And what about Entity Framework, it's already support sequences?
Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
No one else had this problem?
Tổng Bài đăng:
188
Karma:
1176
Đã tham gia:
02/09/2013
Vị trí:
Brazil
It's seens to be a problem releated with AlwaysOn availability of SQL Server 2012 but i did not find a way to turn it back as usually works on the others version's.
Tổng Bài đăng:
40
Karma:
328
Đã tham gia:
14/07/2009
Vị trí:
China
Hi, this problem also troubled me, Have you found a solution to resolve it? Almost all the Identity Increment with this issue in all tables.
Tổng Bài đăng:
10
Karma:
60
Đã tham gia:
14/05/2012
Vị trí:
Netherlands
Is there a good solution for this? My orderid just jumped from 7031 to 8000. I need it to be following orderids!
Tổng Bài đăng:
11362
Karma:
101242
Đã tham gia:
22/05/2011
Vị trí:
United States
Try workaround mentioned above - using a Sequence instead of Identity