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 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Wayne Blosat
 
Posts: n/a

Default SQL Profiler - 05-12-2008 , 02:18 PM





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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

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





Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #3  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #4  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #5  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #6  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #7  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #8  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #9  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
  #10  
Old   
Russell Fields
 
Posts: n/a

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


Wayne,

I don't know what edition of SQL Server you are running, but there is one
issue that often results in more rows returned that the tracer (such as you
or I) would want.

SQL Server 2000 - A empty cell, if being filtered on, is not filtered out.
(Empty (or NULL?) = True)
SQL Server 2005 - Same behaviour, unless you click "Exclude rows that do not
contain values" on the filter form.

FWIW,
RLF

"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

--
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800



Reply With Quote
Reply
Page 1 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