How to do if sqlserver  table identity column exceed limited ?

How to do if sqlserver  table identity column exceed limited ?  That is you can not insert any more.

 

script:

 

select a.TABLE_NAME,a.COLUMN_NAME,a.DATA_TYPE,

       (CASE a.DATA_TYPE when 'int' then 'limited between -2147483648 and 2147483647'

                      when 'bigint' then 'limited between -9223372036854775808 and 9223372036854775807'

                      when 'smallint' then 'limited between -32768 and 3,767'

   when 'decimal' then 'limited between  -10^38 and 10^38 - 1'

                   END 

  ) as "Description",

  c.INCREMENT_VALUE,

  c.LAST_VALUE as "current identity"                                           

from INFORMATION_SCHEMA.COLUMNS a  inner join

                                               SYS.objects  b  on a.TABLE_NAME=b.name

    inner join   SYS.IDENTITY_COLUMNS  c on b.object_id=c.object_id       

where COLUMNPROPERTY(object_id(a.TABLE_SCHEMA+'.'+a.TABLE_NAME), a.COLUMN_NAME, 'IsIdentity') = 1

      and a.COLUMN_NAME=c.name and a.table_name=OBJECT_NAME(c.OBJECT_ID)

order by a.TABLE_NAME

 

 

You can get this result , maybe similar

 

How to do if sqlserver  table identity column exceed limited ?