Script to Get Increment Values of specific Table.

SELECT IDENT_INCR(TABLE_NAME) AS Incremented_Value,
TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME),'TableHasIdentity') = 1
AND TABLE_TYPE = 'BASE TABLE' and
 TABLE_NAME = 'Table_Name';