Sunday, April 15, 2012

DBCC CHECKIDENT

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.

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.

image

1 comment:

  1. 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