• Just list the column names that are being inserted into the new table; you don't have to supply all columns. For example, see below; naturally your specific column names may be different.

    OUTPUT

    DELETED.OID,

    DELETED.Version,

    DELETED.QK,

    DELETED.GD,

    DELETED.Geometry,

    GETDATE()

    --,...

    into table1 ( OID, Version, QK, GD, Geometry, CaptureDate ) --, ...

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.