SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]

by

This is all perfectly normal. Microsoft added sequences in SQL Server 2012, finally, i might add and changed the way identity keys are generated. Have a look here for some explanation.

If you want to have the old behaviour, you can:

  1. use trace flag 272 – this will cause a log record to be generated for each generated identity value. The performance of identity generation may be impacted by turning on this trace flag.
  2. use a sequence generator with the NO CACHE setting (http://msdn.microsoft.com/en-us/library/ff878091.aspx)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Sql to select the rows and ignore the duplicate userid in SQL Server [closed]
  3. Identity increment is jumping in SQL Server database
  4. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  5. get a comma delimited string from rows [duplicate]
  6. T-SQL – Insert Data into Parent and Child Tables
  7. Identity column value suddenly jumps to 1001 in sql server [duplicate]
  8. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  9. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  10. Scope of temporary tables in SQL Server
  11. Sequence vs identity
  12. Count Number of Consecutive Occurrence of values in Table
  13. Get previous and next row from rows selected with (WHERE) conditions
  14. SQL server identity column values start at 0 instead of 1
  15. Convert Date format into DD/MMM/YYYY format in SQL Server
  16. Replace first occurrence of substring in a string in SQL
  17. Can SQL Server Express LocalDB be connected to remotely?
  18. How to correctly insert newline in nvarchar [duplicate]
  19. Find min and max for subsets of consecutive rows – gaps and islands
  20. Group All Related Records in Many to Many Relationship, SQL graph connected components
  21. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  22. How to subtract 30 days from the current date using SQL Server
  23. Cannot Resolve Collation Conflict
  24. Try_Convert for SQL Server 2008 R2
  25. How to get Previous Value for Null Values
  26. Can’t create stored procedure with table output parameter
  27. SQL Server: +(unary) operator on non-numeric Strings
  28. How to insert into a table with just one IDENTITY column?
  29. How to automatically generate unique id in SQL like UID12345678?
  30. Why do you create a View in a database?

Leave a Comment