Post reply

Profiler: Multiple Filters On TextData Column

  • June 19, 2009 at 3:42 am

    #135371

    I need to identify if a database view is still be used by our application. I'm setting up a server side trace to try and capture this information (same difficulty exists using the Profiler GUI). The database view is called 'customers', but I have many other tables called customers_%.

    So I'm trying to filter TextData NOT LIKE '%Customers_%' AND TextData LIKE '%Customers%. Should this work, as my trace file receives nothing?

    Or is there a better way for capturing this data. Thanks.

    Andy

  • June 19, 2009 at 3:56 am

    #1012251

    The condition will cancel each other.

    Why don't you try '% customers %' assuming there will be a space before and after the view in your query

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 19, 2009 at 7:19 am

    #1012372

    Thanks Roshan.

    I'm not sure that trailing space will always be present. I had assumed as the syntax is support by T-SQL, it would also work in Profiler:rolleyes:

    Thanks again for your advice.

    Andy

Viewing 3 posts - 1 through 2 (of 2 total)

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