Say I create a create a table with an identity, and before inserting any records, perform a reseed.

create table dbo.mytest(x bigint identity(1,1), y char(1)) 
DBCC CHECKIDENT ( 'mytest', RESEED, 2200000000 )

Doing these show the old value of 1

sp_help 'mytest'

select object_name(object_id) as obj_name, name AS column_name, seed_value
from sys.identity_columns where object_name(object_id) = 'mytest'

Only this shows the reseeded value

select IDENT_CURRENT( 'mytest' )  

Is that a bug? I'm using SQL Server 2017 CU15.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.