>HI All,
>
>Is there an equivalent in SQL to the VFP _Triggerlevel system variable?
>
>The scenario I am trying to cope with is as follows:
>
>When an order line is deleted by the user I want to write a record to another database via the order line delete trigger.
>
>When an order header record is deleted I want the order header delete trigger to delete the child order lines but I do NOT want the order line delete trigger to write records to the other database. I only want to capture the order lines that have been deleted by direct user action.
>
>In VFP I could achieve this by checking the _triggerlevel variable.
>
>TIA,
>
>Andy

Check TRIGGER_NESTLEVEL in BOL