• GilaMonster is correct about the Select Into. But if you are trying to create an insert trigger after an insert into a table in most other ways there are numerous examples of how to build that trigger.

    SOmething like the normal

    CREATE TRIGGER myAfterInsertTrigger

    ON mytable

    AFTER INSERT

    AS

    ...

    GO

    Not all gray hairs are Dinosaurs!