SQL Profiler Filters

From: Derek Ruesch (DerekRuesch_at_discussions.microsoft.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 10:45:01 -0800

I have a SQL Profiler trace that has the following filters applied:

Application Name Not Like SQL Profiler
TextData Not Like SELECT

I want this trace to not include SQL Profiler events and SQL "Select"
statements.

The trace does not show SQL Profiler events but it does still show "Select"
SQL statements. Why is it still showing SQL Select statements?

Thanks for the help.

Derek Ruesch

Relevant Pages

  • Re: Getting Recent Search Terms
    ... I can't get your trace to work. ... > the SQL Profiler GUI in production environments. ... This script or any other profiler server-side script can be ... > "Hilary Cotter" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Access Linked server generates (Error 7399 / 7312)
    ... i'll try to trace the problem if it occuurs again. ... > I was thinking of SQL Profiler, which requires a sysadmin on the SQL ... > reproduce the problem. ... >>think SP on my actual server is SP1. ...
    (microsoft.public.data.oledb)
  • Re: Access Linked server generates (Error 7399 / 7312)
    ... I was thinking of SQL Profiler, which requires a sysadmin on the SQL ... Server box to set up and configure. ... If you could create a trace on ... >>>I restarted the jobs when the problem occured, ...
    (microsoft.public.data.oledb)
  • Re: Detect "calling" stored proc?
    ... You can use SQL Profiler to find out by which procedure the second procedure ... is called if you trace the SQL:StmtStarted or SQL:StmtCompleted events. ... CREATE PROC usp_inner ... > that called the currently executing stored proc? ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Profiler Filters
    ... I am had some problems with multiple filters working correctly together, ... There may be a bug in the trace ... If you are using SQL 2000, ... > Application Name Not Like SQL Profiler ...
    (microsoft.public.sqlserver.tools)
Loading