• just realised after pasting the error

    Msg 102, Level 15, State 1, Procedure Trig_NewServer, Line 7

    Incorrect syntax near 'inserted'.

    I was missing END after inserted.. what a fool! (me of course)