Helen Borrie wrote:

>>
>>Is it possible to fire an event off when the DepartmentId changes?
>
> Yes, in a Before or After Update trigger, call Post_Event. Understand,
> though, that the event won't be detected by the watchers until (and unless)
> the transaction commits.

To emphasize, the Post_Event statement queues an event for delivery, but
the event is not actually delivered until your transaction commits.

Regards,


Ann