Replication Script

-- Simple Script for SQL Server 2000 showing 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