declare @Table_name varchar(60)

set @Table_name = '';

if Exists(Select top 1 1 from sysobjects

           Where objectproperty(id, 'TableHasIdentity') = 1             and upper(name) = upper(@Table_name)         )     select 1else select 0

-- or

if Exists(Select top 1 1 from sysobjects so

           Where so.xtype = 'U'             and upper(so.name) = upper(@Table_name)             and Exists(Select Top 1 1 from syscolumns sc                         Where sc.id = so.id                           and columnproperty(sc.id, sc.name, 'IsIdentity') = 1                       )         )       select 1else select 0