none
CLR Trigger source table identification RRS feed

  • Question

  • Hello everybody

     

    I am designing audit CLR triggerfor INSERT, DELETE and UPDATE.

    When trigger fires, insert some audit data to special audit table to identify to which table, who, when and what insert (update or delete).

    Everything is going fine but i have jam...

    I am creating many triggers on many tables from one assembly. I want trace DML query on this many tables and need identify table names targeted by INSERT, UPDATE or DELETE operation alias witch table is target by DML operation and fire DML CLR trigger...

     

    Thank you for help

     

    Hermes

     

    Wednesday, November 7, 2007 1:55 PM

All replies

  • Hi,

    Could you tell us what your problem is in detail so that we can better help you?

     

    Regards

    Jing

    Thursday, May 8, 2008 9:34 AM