SELECT 
   IDENT_SEED(TABLE_NAME) AS Seed,
   IDENT_INCR(TABLE_NAME) AS Increment,
   IDENT_CURRENT(TABLE_NAME) AS Current_Identity,
   TABLE_NAME
FROM 
   INFORMATION_SCHEMA.TABLES
WHERE 
   OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1 AND 
   TABLE_TYPE = 'BASE TABLE'

http://blog.sqlauthority.com/2007/04/23/sql-server-query-to-find-seed-values-increment-values-and-current-identity-column-value-of-the-table/

Thanks to  Pinal Dave (http://blog.SQLAuthority.com).

MS SQL - Select Seed, Increment and Current Identity  Values

SQL