try this (written for SQL2005 / SQL2008)
select objects.name as Object_Name, columns.name as column_name
from sys.objects
join sys.columns on columns.object_id = objects.object_id
where is_identity = 1
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”