How can I tell what columns in my SQL Server database are identity columns?

A. The following scripts work on SQL 6.5.

To show all identity columns :-

select o.name, c.name from <dbname>..syscolumns c, <dbname>..sysobjects o
where c.id=o.id and (c.status & 128)=128

To tell the identity seed : select ident_seed('<tblname>')

To tell the identity increment : select ident_incr('<tblname>')

---