I have read both your articles. second one is more useful for me. Will be waiting for future articles from you.

Thank you.

Good article! Could learn some new things.

You got me there!

Yes, Celko is referring to primary keys.

That was my favorite...

Good article! very informative. Thank you.

Explanation was very clear. neat examples.

Excellent article by Serhiy Snisarenko !!

I was looking for a such an automation script for some time. Liked the first part of the article and learned some good DOS...

I use the following script to get the tables having identity values....

SELECT table_name

      ,column_name

      ,IDENT_CURRENT(table_name) as Identity_value

      ,data_type

 FROM information_schema.columns

WHERE COLUMNPROPERTY(OBJECT_ID(table_name),column_name,'IsIdentity')=1

ORDER BY table_name

Why bother with system tables, when you can...