Re: SQL Profiler Filters

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 01/18/05

  • Next message: Kalen Delaney: "Re: SQL Profiler Filters" 
    Date: Tue, 18 Jan 2005 15:56:04 -0500

    Did you by any chance include the single-quotes? 

    -- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Derek Ruesch" <DerekRuesch@discussions.microsoft.com> wrote in message
news:D729EBE1-5832-4EE4-BC0F-BB00958703E7@microsoft.com...
> This did not work. After this did not work I tried
> TextData  LIKE  UPDATE and TextData  LIKE  '%UPDATE%' (so that the trace
> would only track UPDATE sql statements). This blocked all SQL statements,
> including UPDATE statements.
>
> Any more ideas?
>
> Thank you for your help.
>
> Derek
>
> "Adam Machanic" wrote:
>
> > Try:
> >
> > TextData Not Like '%SELECT%'
> >
> > -- 
> > Adam Machanic
> > SQL Server MVP
> > http://www.sqljunkies.com/weblog/amachanic
> > --
> >
  • Next message: Kalen Delaney: "Re: SQL Profiler Filters"

    Relevant Pages

    • Re: Profiler
      ... Kalen Delaney ... SQL Server MVP ... "Bob" wrote in message ... > there are 100s of rows with empty values for the textdata ...
      (microsoft.public.sqlserver.server)
    • Re: SQL Profiler Filters
      ... Yet another reason not to use ad hoc SQL :-) ... SQL Server MVP ... >>TextData Not Like '%SELECT%' ... > Best, Hugo ...
      (microsoft.public.sqlserver.tools)