SQL Server seed value lower than max identity -



SQL Server seed value lower than max identity -

i have table contains a column, integer, specified auto-incrementing primary key.

create table [dbo].[table] ( [tablekey] [int] identity(1,1) not replication not null, [...] constraint [pk_tablekey] primary key clustered ( [tablekey] asc ) ( pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on, fillfactor = 80 ) on [primary] ) on [primary]

this table has been having anywhere 0 - 7000 records inserted m-f, without issue. lastly fri ~4k records inserted identity values starting @ 2,064,682 , ending @ 2,068,076. morning received error...

violation of primary key constraint 'pk_tablekey'. cannot insert duplicate key in object 'dbo.table'. duplicate key value (2067844).

after going downwards lot of wrong paths found current seed table 2067845.

my question is, because cannot find related, how happen? see, , understand, why may see higher seed max identity, not other way around.

any help appreciated.

sql server 2012 identity column has been problematic ever since release of 2012, skipping identity values, not next seed correctly etc...

you can log bug microsoft @ microsoft connect.

here of other knows bugs logged on connect identity column

identity column jumps seed value

failover or restart results in reseed of identity

also prepare can execute next commands

dbcc checkident('tablename', reseed, 0) --<-- smallest value 0 trick dbcc checkident('tablename', reseed) --<-- without seed value

this reseed identity column next available highest identity value. saving future duplicate issues.

sql-server sql-server-2012 identity

Comments

Post a Comment

Popular posts from this blog

php - How to pass multiple values from url -

php - How to pass multiple values from url - i'm trying pass textbox , 1 select result value 1 page page.using url.but it's display error message. "parse error: syntax error, unexpected '' (t_encapsed_and_whitespace), expecting identifier (t_string) or variable (t_variable) or number (t_num_string) in c:.." while($value= mysqli_fetch_assoc($result)){ $apid=$value['apid']; echo("<tr> <td>". $value['apid'] ."</td> <td>".$value['email']."</td> <td>".$value['comments']."</td> <td>".'<input type="text" name="payment"/>'."</td> <td>"."<input type='text' name='apid' value='".$apid."' style='visibility:hidden' size='2'>"."</a>"."<a hre...
Read more

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* - i've inherited doc publishing process takes docbook , builds html , pdf output, using apache fop both. project had been started, never completed. lots of tweaking, i've able of doc sets build (20+), except handful, , fail severe code 1 of these 2 conditions: "fo:flow" missing kid elements. required content model: marker* "fo:block" not valid kid of "fo:root" the xml output comes out of docbook , docbook-fop checks out well-formed. the fop error in 1 book, "endecagloss", example, points end of string: <fo:flow flow-name="xsl-region-body" start-indent="4pc" end-indent="0pt"/> here’s log output in case: [java] severe: javax.xml.transform.transformerexception: file:/scratch/publishing/hudson/jobs/build-main-endeca-documentation/workspace/serverdoc/w...
Read more

database - php search bar when I press submit with nothing in the search bar it shows all the data -

database - php search bar when I press submit with nothing in the search bar it shows all the data - the search fusion works correctly if press submit nil in search bar shows data. how message show saying nil has been entered search bar ?.i new php. <?php $mysql_host="host"; $mysql_database="database"; $mysql_user="username"; $mysql_password="password"; $dbconnect=@mysql_connect($mysql_host, $mysql_user, $mysql_password); // trys connect database if (!$dbconnect) { exit("an error has occurred - not connect database."); // if couldn't connect, allow user know } if(!mysql_select_db($mysql_database)) { exit("an error has occurred - not select database."); //if couldn't select db, allow user know } $output = ''; //collect if(isset($_post['search'])...
Read more