dbTalk Databases Forums  

profiler not showing certain fields

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


Discuss profiler not showing certain fields in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Franky
 
Posts: n/a

Default profiler not showing certain fields - 06-17-2004 , 06:23 AM






I am using profiler to monitor a remote sql server.
When I select a trace template, all fields included in that trace are visible. The extra fields I added manually are shown in the header but without values.

Can someone help me with this problem

thx

Reply With Quote
  #2  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: profiler not showing certain fields - 06-17-2004 , 06:54 AM






An event only produce values for a certain number of columns. The columns that each event produces
values for are documented in Books Online.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Franky" <Franky (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am using profiler to monitor a remote sql server.
When I select a trace template, all fields included in that trace are visible. The extra fields I
added manually are shown in the header but without values.

Can someone help me with this problem

thx



Reply With Quote
  #3  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: profiler not showing certain fields - 06-17-2004 , 07:06 AM



Some data columns will not have data for certain events.
Just adding the columns does not guarantee they will have
data for every event.

-Sue

On Thu, 17 Jun 2004 04:23:01 -0700, Franky
<Franky (AT) discussions (DOT) microsoft.com> wrote:

Quote:
I am using profiler to monitor a remote sql server.
When I select a trace template, all fields included in that trace are visible. The extra fields I added manually are shown in the header but without values.

Can someone help me with this problem

thx


Reply With Quote
Reply




Thread Tools
Display Modes

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.