Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values : DBCC « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. DBCC

DBCC CHECKIDENT checks the current maximum value for the specified table.
The syntax for this command is as follows:
DBCC CHECKIDENT
(
'table_name'
    [ , {
    NORESEED | { RESEED [ , new_reseed_value ] }
        }
    ]
)
[ WITH NO_INFOMSGS ]

NORESEED      NORESEED means that no action is taken other then to report the maximum identity value.
RESEED       RESEED specifies what the current IDENTITY value should be.
new_reseed_value      The new current IDENTITY value.
WITH NO_INFOMSGS      WITH NO_INFOMSGS suppresses informational messages from the DBCC output.