SQLTeam.com | Weblogs | Forums

DBCC Check Identity

Hello,

We exprienced an error while executing the DBCC CheckIdent with unusual result.

Query : DBCC CheckIdent('tablename',noreseed)
Result:
"Checking identity information: current identity value 'NULL', current column value
'23016232'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

What might be the reason having a NULL value on it?

No row has ever been loaded to the table.

What do you mean by this? it has about 4 million records on it.