• David Lu (6/17/2010)


    Hi Jason:

    It works very well for me. It is in prod now, after running on QA.

    It almost covers everything I need to know, just one more:

    Is it possible to get the called proc/func parameter value in the QueryText field?:-)

    Thanks a lot

    David

    I haven't tried that. I would typically use a trace to find that. Sounds like something to try.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events