Post reply

SQL Profiler - Easy question from a beginner!

  • July 3, 2006 at 7:44 am

    #94475

    Any help appreciated!

    I'm running a trace using SQL profiler - what i need to capture is one particular select statement and ignore everything else.

    I've got this working to an extent - all other types of activitiy are excluded updates, inserts etc. but  I still get other select statements that I don't want to return.

    I'm not sure how you can exclude everything except one particular text string.

    Also using substring syntax rather than like statements in the filters would be helpful - is that possible?

    Craig

     

     

  • July 3, 2006 at 10:22 am

    #647263

    Unless the select is issued by a certain user, or from a certain stored procedure, or a certain application, or a certain machine, I don't think you'll be able to eliminate all the unwanted selects.

  • July 4, 2006 at 3:01 am

    #647332

    Thanks for the response - I couldn't find a way to do it but I'd hoped it would have been possible. Unfortunatley the query is generated from a 3rd party application that is not using anything distinct that I can filter on rather than the exact select statement. I would have thought it was a reasonably common request to use an exact match rather than LIKE / NOT LIKE. I guess this must be something fundamental in the method of tracing.

    Cheers anyway.

    Craig

     

     

     

  • July 4, 2006 at 10:19 am

    #647375

    If you set profiler to log to a table, then you can remove any unneccesary statements once the trace finishes.

    Ally

  • July 5, 2006 at 2:46 am

    #647435

    Yes - that works no problem

    All sorted now

     

    Thanks,

    Craig

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply