Though this not a big deal but thought of mentioning it here. DBCC CHECKIDENT has two options, RESEED and NORESEED.
If previous SQL Server versions output message of the DBCC CHECKIDENT will be similar for both the options as shown in the below image.
However, in SQL Server 2012 RESEED option will not provide the current IDENTITY valueas it is already specified with the parameter as shown below.
Thank you for bring this up - Reseed, as part of this database console command, is very important after doing a huge bunch of inserts with ID values (when syncing up between databases Set Identity_Insert ON - OFF before and after btw) - it will allow you to ensure that the IDs stay consistent.
ReplyDelete