identity overflow 검사하기

-- SQL2000

select object_name(id) as table_nam

, name

,    'Seed'     = ident_seed(object_name(id))

,    'Increment'    = ident_incr(object_name(id))

,    'current'     = IDENT_CURRENT(object_name(id))

, max_value =

 case

  when length =  2 then  32767

  when length =  4 then  2147483647

  when length =  8 then  9223372036854775807  

 else 'etc'

      end

from syscolumns

where status = 128

GO

 

-- SQL2005,2008

select object_name(object_id) as table_nam

, name

,    'Seed'     = ident_seed(object_schema_name(object_id) + '.' + object_name(object_id))

,    'Increment'    = ident_incr(object_schema_name(object_id) + '.' + object_name(object_id))

,    'current'     = IDENT_CURRENT(object_schema_name(object_id) + '.' + object_name(object_id))

, max_value =

 case

  when max_length =  2 then  32767

  when max_length =  4 then  2147483647

  when max_length =  8 then  9223372036854775807          

 else 'etc'

      end

from sys.columns

where is_identity = 1

and name <> 'queuing_order'

go

http://cafe.naver.com/sqlmvp/433
[출처] identity overflow 검사하기(스키마 있는경우) (sqlmvp) |작성자 차주언