Consider I am having a table ([DBO].[WBCustomer]) with IDENTITY column ID. Truncate table [DBO].[WBCustomer] DBCC CHECKIDENT ('[DBO].[WBCustomer]', RESEED, 1) WHEN I give select IDENT_CURRENT('[DBO].[WBCustomer]') gives me 1 After inserting a record, it gives me 1. Since I having another column PID which is primary key column in the table([DBO].[WBCustomer]). I have to insert like E1, E2 Since both the time it returns the same value(i.e. after reseed and inserting a single record) primary key violation error occurred. Thanks.