How to Check Identity Value

DBCC CHECKIDENT

 (

    table_name

        [, { NORESEED | { RESEED [, new_reseed_value ] } } ]

)

DBCC CHECKIDENT (table)

DBCC CHECKIDENT (table, NORESEED)

DBCC CHECKIDENT (table, RESEED, 10)