• The following way to find indentities is returning invalid results:

    SELECT table_name, column_name, ordinal_position orgPostion, data_type

      FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)

     where COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity') = 1

    order by table_name, column_name

    It returns an integer field from a view as an identity.  The source of this view is a table in another database.  The base table does not have an identity defined.  The field is an "int not null."

    You will need to filter out views.