Forum Discussion

Copper Contributor

Aug 15, 2023

Identity column set to seed from 1 inserts 0 in sql server

Hi, I have a peculiar problem when the first record is inserted into "[dbo].[EQP_CRITICALITY]" table. When the first record is inserted into this table, the Identity PK column has 0, but it was exp...

hnarahari

Copper Contributor

Aug 17, 2023

Hi bake13,
The SQL server version is "Microsoft SQL Server 2019 (RTM-GDR) (KB5021125) - 15.0.2101.7 (X64)".
Thanks.

bake13

Microsoft

Aug 18, 2023

Hi hnarahari -- Thank you for the information. I'm not aware of a known issue. Could you please outline the exact steps used to reproduce this behavior? Take care.