Here goes the trigger code...

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

ALTER TRIGGER [dbo].[InsertReservationTrigger] ON [Euronext].[dbo].[Reservations]

After Insert

AS

--Declare @Max_ReservationID bigint

Begin

--Select @Max_ReservationID = max(Reservation_ID) from Euronext.dbo.Reservations

Insert...