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
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?