SELECT IDENT_SEED(TABLE_NAME) AS Seed_Value,TABLE_NAMEFROM INFORMATION_SCHEMA.TABLESWHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME),'TableHasIdentity') = 1AND TABLE_TYPE = 'BASE TABLE' andTABLE_NAME = 'YOUR_TABLE_NAME';
Login to post response