Post reply

SQL Server profiler -> column filter "Error"

  • June 10, 2009 at 8:01 am

    #205356

    Hello together,

    I am examine the data traffic of an specific application.

    Now I am searching for the possibility to filter the sql statements which causes for example constraint violations.

    I already used the column filter "Error", but without success.

    Is there a possibility to reach my aim?

    Regards,

    Daniel

  • June 10, 2009 at 8:31 am

    #1007446

    check books online for fn_trace_gettable

    it is very helpful in tracking down and filtring information through T-SQL.

    I would suggest to use '%%' in the like clause in textdata column, while filtering it through Profiler itself and if this doesnt work try without the %%.

    Maninder
    www.dbanation.com

  • June 10, 2009 at 9:05 am

    #1007467

    1. Select the Event 'User Error Message' Under 'Errors & Warnings' Event Group. It will show you the actual Constraints' Error messages

    2. Filter the column TextData as %Message You want to filter%

    Regards

  • June 12, 2009 at 3:43 am

    #1008469

    Great. That's what I am looking for.

    Regards,

    Daniel

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

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