I don't believe that there is a global variable that contains the table being updated within a trigger. But you know what table is being updated when you create the trigger.
-Mike
>>>Yes, misspelling is a problem. On the other hand, it would simplify updating a client site as product evolves and new tables are added.
>>
>>True, but you could do the same thing explicitly with a script when the application was deployed.
>>
>>To answer your original question, if the variable's value was NULL, the requested table probably didn't exist and you could insert the row at that point.
>>
>>But I still don't think it's a good idea.
>>
>
>Mike, sorry to continue this. Assuming the SP is called from the Insert trigger of the table, is there any way for the SP to know from what table's event it was called? Something like a @@variable that told?
>
>Thanks again.
>
>Alex