Listar todos los campos identity dentro de una base de datos - SQL Server

USE NombreDeLaBaseDeDatos

GO

SELECT o.name AS Tabla , c.name AS Campo

FROM syscolumns c, sysobjects o

WHERE c.STATUS & 128 = 128

AND o.id = c.id

ORDER BY o.name