Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Sep 01, 2012 12:54 AM by Keep it Simple
Member
110 Points
65 Posts
Apr 26, 2012 05:00 PM|LINK
Hi. The identity Id. record new samples; Id no = 101, 102, 103 but sometimes the line is not. 1000 skips. 103,104,1005,1006,1007 samples, 1208. why this happens. struggled for hours. removed the primary key. I was active again. problem is not resolved.
Contributor
4394 Points
1102 Posts
Apr 26, 2012 05:38 PM|LINK
That would only happen if records were deleted. Were records deleted?
Apr 26, 2012 05:42 PM|LINK
no, do not delete records. so many tables. sequence is not. 1000 steps.
All-Star
15741 Points
2724 Posts
Apr 26, 2012 06:10 PM|LINK
It could also happen if someone reseeded the table with a command like this one:
http://msdn.microsoft.com/en-us/library/ms176057.aspx
I don't know of any way that it could just happen spontaneously.
Apr 26, 2012 06:23 PM|LINK
the problem continues. Id = 205,206,206, the next value in 1027
Star
14460 Points
2402 Posts
Apr 27, 2012 06:52 AM|LINK
blackseacoder the problem continues. Id = 205,206,206, the next value in 1027
If insert statement contain errors, then Identity value is keep changing.
Suppose, we fire insert statement that contain errors of 100 times, Identity value change 100 times.
I think you are facing the same problem of insert statement errro.
Apr 27, 2012 08:18 AM|LINK
https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity
549 Points
264 Posts
Sep 01, 2012 12:54 AM|LINK
I have the same problem and just found your post now.
My post is at: http://forums.asp.net/p/1839194/5129431.aspx/1?Re+Primary+Key+jumped+by+1000+SQL+Server+2012
blackseacode...
Member
110 Points
65 Posts
SQL 2012 Identy Column
Apr 26, 2012 05:00 PM|LINK
Hi. The identity Id. record new samples; Id no = 101, 102, 103 but sometimes the line is not. 1000 skips. 103,104,1005,1006,1007 samples, 1208. why this happens. struggled for hours. removed the primary key. I was active again. problem is not resolved.
adamturner34
Contributor
4394 Points
1102 Posts
Re: SQL 2012 Identy Column
Apr 26, 2012 05:38 PM|LINK
That would only happen if records were deleted. Were records deleted?
blackseacode...
Member
110 Points
65 Posts
Re: SQL 2012 Identy Column
Apr 26, 2012 05:42 PM|LINK
no, do not delete records. so many tables. sequence is not. 1000 steps.
TabAlleman
All-Star
15741 Points
2724 Posts
Re: SQL 2012 Identy Column
Apr 26, 2012 06:10 PM|LINK
It could also happen if someone reseeded the table with a command like this one:
http://msdn.microsoft.com/en-us/library/ms176057.aspx
I don't know of any way that it could just happen spontaneously.
blackseacode...
Member
110 Points
65 Posts
Re: SQL 2012 Identy Column
Apr 26, 2012 06:23 PM|LINK
the problem continues. Id = 205,206,206, the next value in 1027
yrb.yogi
Star
14460 Points
2402 Posts
Re: SQL 2012 Identy Column
Apr 27, 2012 06:52 AM|LINK
If insert statement contain errors, then Identity value is keep changing.
Suppose, we fire insert statement that contain errors of 100 times, Identity value change 100 times.
I think you are facing the same problem of insert statement errro.
.Net All About
blackseacode...
Member
110 Points
65 Posts
Re: SQL 2012 Identy Column
Apr 27, 2012 08:18 AM|LINK
https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity
Keep it Simp...
Member
549 Points
264 Posts
Re: SQL 2012 Identy Column
Sep 01, 2012 12:54 AM|LINK
I have the same problem and just found your post now.
My post is at: http://forums.asp.net/p/1839194/5129431.aspx/1?Re+Primary+Key+jumped+by+1000+SQL+Server+2012