That correct. The trigger is fired after the DML has been applied to the table. One important note - the trigger is fired once no matter how many rows are affected by the DML. That can be zero, one, or more. The trigger will only fire once per DML.

-Mike

>Michael
>
>Thanks for the guidance, when the trigger fires, I assume the update/Insert has taken place? and I can then reference it as part of the update statement on the other table?
>
>

>CREATE TRIGGER tr_meetings_insertupdate
> ON meetings
> FOR INSERT, UPDATE
>AS
> IF UPDATE(isCancelled)
>  BEGIN
>   UPDATE calendar
>   SET slottaken = 0
>         WHERE calendar.begintime between meetings.begintime and meetings.endtime
>         and   calendar.roomid = meetings.RoomID
>  END
>

>
>
>Thanks Again