-- Tables with Identity columns without the 'Not for Replication' attribute

SELECT sysobjects.name as TableName, syscolumns.name as ColumnName 
FROM sysobjects INNER JOIN
syscolumns ON sysobjects.id = syscolumns.id
WHERE (sysobjects.name like 'ti%')
and colstat & 0x0001 = 1
and colstat & 0x0008 = 0