• You were also missing the END that matched the opening BEGIN. If you do not plan on doing any custom error handling, e.g. enriching the error message, in the trigger then I would recommend completely removing the TRY/CATCH and go with something simple like this:

    USE DEV2

    GO

    CREATE TRIGGER [dbo].[RPT_Trans_Audit] ON [RPT_Trans]

    AFTER INSERT, UPDATE, DELETE

    AS

    BEGIN

    SET NOCOUNT ON;

    INSERT INTO [dbo].[RPT_Trans_Audit]

    (

    Package_ID,

    Received_Date,

    Download_Date

    )

    SELECT Package_ID,

    Received_Date,

    Download_Date

    FROM INSERTED;

    END

    GO

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato