I have created a trigger which should fire when data in the RawStatus field is updated for a custom poller I have created.
I can from Query Analyzer run an Update statement to change the field and the trigger fires no problem. I can see the RawStatus field changing without intervention but no trigger.
Does anyone know how the data in the CustomPollerStatus is populated/amanded? Also does it update the table in Sets? (Causing the trigger to fail).
Any help would be gratefully recieved.