Jay, I think this is what you were afer. Whether the Identity property is set for a column is stored in the staus column of syscolumns (encoded in a hex string of course).if x'80' is on then it is an Identity column.

SELECT name, status

from syscolumns

Where id= object_ID('yourtable')

Toni