appliedsql.net
Find Increment Values and Current Identity value of all tables in a database
Use DatabaseName Go SELECT IDENT_SEED(TABLE_NAME) AS SeedValue, IDENT_INCR(TABLE_NAME) AS IncrementValue, IDENT_CURRENT(TABLE_NAME) AS Current_Identity_Value, TABLE_NAME FROM INFORMATION_SCHEMA.TAB…