During bulk insert IDENTITY column maximal value is above 9 000 000!Īs it was not normal load but mass insert - there was no rollback, restart nor any other issue during this operation. We truncate the table, and bulk insert 70 000 records. In my case ( we are using named instance of MS SQL Server 2008 R2 Standard 64 bit SP3) gaps are simply gigantic.Īpplication inserted 130 000 records in table, and "Arithmetic overflow IDENTITY conversion to int" error occurred. But basically people say it is related to transactions or restarts. I have read many questions about IDENTITY increments in SQL Server and strange gaps between them. This question is about strange behavior in MS SQL 2008 Server Standard R2 SP3
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |