discepancy between dbcc checkident and select IDENT_CURRENT

• Michael.Gagne

  SSC-Addicted

  Points: 442

  More actions

  December 16, 2013 at 11:46 am

  #283599

  Hi there

  I am getting different results between DBCC CHECKIDENT and select IDENT_CURRENT().

  Here are my results:

  dbcc checkident('tableA', noreseed)

  Checking identity information: current identity value 'NULL', current column value '310557'.

  DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  select IDENT_CURRENT('tableA')

  280001

  A few questions:

  1. What is significance of the first part of the dbcc command (ie: current identity value 'NULL')

  2. TableA resides on a subscription database and the result of IDENT_CURRENT() matches the check constraint. Why are the results of DBCC so different?

  Thank you,

  Mike G