When I run the script
DBCC CHECKIDENT ('table name', RESEED, 20000)
the output of the message is
Checking identity information: current identity value '200000', current
column value '200000'. DBCC Execution completed. If DBCC printed error
messages, contact your system administrator.
When I query the identity value by running
SELECT IDENT_CURRENT('table_name')
it is showing up as 200000 as expected, however, when the developer inserts records into the table, it's not using the new reseeded value.
Is there something obvious I'm missing?