CHECKIDENT

OBJECTIVE: To find out the current identity value in the current table, use the below syntax to find out.
USE DATABASENAME
go
DBCC CHECKIDENT ("DBO.TABLENAME", NORESEED);

For further scripts documentation: Microsoft library