DECLARE @TableName AS NVARCHAR(MAX)
DECLARE @ColName AS NVARCHAR(MAX)

DECLARE emp_cursor CURSOR FOR     
SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMNPROPERTY(object_id(TABLE_SCHEMA+'.'+TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
ORDER BY TABLE_NAME    
  
OPEN emp_cursor   

FETCH NEXT FROM emp_cursor     
INTO @ColName,@TableName 

WHILE @@FETCH_STATUS = 0    
BEGIN   
--PRINT @ColName ; PRINT @TableName
DECLARE @MaxId  AS INT
EXEC ('DECLARE @MaxId  AS INT;
       DECLARE @TableName  AS NVARCHAR(MAX)='''+@TableName+''';
       SELECT @MaxId=ISNULL(MAX(' + @ColName + '),0)+1 FROM '+@TableName+';'+
       'DBCC CHECKIDENT ('+@TableName+', RESEED,@MaxId);'+
       'PRINT ''Table: ''+ @TableName +'', New Identity Val:''+CAST(@MaxId AS NVARCHAR);PRINT CHAR(13);'
)
FETCH NEXT FROM emp_cursor
INTO @ColName,@TableName
END 

CLOSE emp_cursor;    
DEALLOCATE emp_cursor;