dbTalk Databases Forums  

SQL Profiler

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL Profiler

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Profiler in the microsoft.public.sqlserver.tools forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM





Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #12  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM





Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #13  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #14  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #15  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #16  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #17  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #18  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
  #19  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Profiler - 05-12-2008 , 02:42 PM


Are you seeing rows with other values in that column? Or do you only see
rows with either the values you expecting, or with no value (blank/NULL)?

The former would suggest that the filter is not applied correctly.

The latter would suggest that you didn't check "Exclude rows that do not
contain values" on the "Edit Filter" dialog. This is not the most intuitive
behavior in the world, and I sure wish they would change the default status
of that checkbox to be checked.

A



On 5/12/08 3:18 PM, in article OScV1TGtIHA.552 (AT) TK2MSFTNGP06 (DOT) phx.gbl, "Wayne
Blosat" <wblosat (AT) proconsrv (DOT) com> wrote:

Quote:
I can never seem to get the filters to work in SQL Profiler. I've tried to
set HOSTNAME and NTUSERNAME to mine however when I run the trace all
connection request are shown. Am I missing something???

Thanks


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top