Home Forums Programming CLR Integration and Programming. How does a C# CLR trigger know the table it was called for? RE: How does a C# CLR trigger know the table it was called for?

  • October 21, 2012 at 1:12 pm

    #1551183

    R.P.Rozema (10/21/2012)

    So, I hear your warnings, but I still think it's worth at least the experiment. The only issue I have is that I do not want to have to write/generate and then compile a separate CLR routine for each table.

    Stongly agree with you on both points. Like my Dad says, "One experiment is wortha thousand 'expert' opinions." 😀

    On the other hand, without a way to determine the table the CLR audit trigger was fired for, the entire setup doesn't have any chance of succeeding.

    Did you see my last post above? That might be way but don't know how it would be implemented 'cause I'm not a C# Programmer.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)