dbTalk Databases Forums  

SQL Server 2005 - Server side trace script

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL Server 2005 - Server side trace script

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


Discuss SQL Server 2005 - Server side trace script in the microsoft.public.sqlserver.tools forum.



Reply
Page 7 of 7 < 1 2 3 4 5 6 7
 
Thread Tools Display Modes
  #61  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL Server 2005 - Server side trace script - 07-31-2008 , 05:07 PM





Andrew J. Kelly (sqlmvpnooospam (AT) shadhawk (DOT) com) writes:
Quote:
I will ask again. Did you ensure that the TextData column is checked off
as one of the columns in Profiler in the first place? You can add or
remove any columns or events that you want and TextData is not one of
the selected columns by default for an RPC event.
Actually, I seem to recall having made the same observation as Anand.
If I have a server-side trace, and open it in Profiler, TextData is
missing for some RPC events, although it's returned by fn_trace_gettable.
It was a while since I ran into this, but it may be that if I include
BinaryData in the trace, this does not happen.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #62  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL Server 2005 - Server side trace script - 07-31-2008 , 05:07 PM





Andrew J. Kelly (sqlmvpnooospam (AT) shadhawk (DOT) com) writes:
Quote:
I will ask again. Did you ensure that the TextData column is checked off
as one of the columns in Profiler in the first place? You can add or
remove any columns or events that you want and TextData is not one of
the selected columns by default for an RPC event.
Actually, I seem to recall having made the same observation as Anand.
If I have a server-side trace, and open it in Profiler, TextData is
missing for some RPC events, although it's returned by fn_trace_gettable.
It was a while since I ran into this, but it may be that if I include
BinaryData in the trace, this does not happen.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #63  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL Server 2005 - Server side trace script - 07-31-2008 , 05:07 PM


Andrew J. Kelly (sqlmvpnooospam (AT) shadhawk (DOT) com) writes:
Quote:
I will ask again. Did you ensure that the TextData column is checked off
as one of the columns in Profiler in the first place? You can add or
remove any columns or events that you want and TextData is not one of
the selected columns by default for an RPC event.
Actually, I seem to recall having made the same observation as Anand.
If I have a server-side trace, and open it in Profiler, TextData is
missing for some RPC events, although it's returned by fn_trace_gettable.
It was a while since I ran into this, but it may be that if I include
BinaryData in the trace, this does not happen.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #64  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: SQL Server 2005 - Server side trace script - 07-31-2008 , 05:07 PM


Andrew J. Kelly (sqlmvpnooospam (AT) shadhawk (DOT) com) writes:
Quote:
I will ask again. Did you ensure that the TextData column is checked off
as one of the columns in Profiler in the first place? You can add or
remove any columns or events that you want and TextData is not one of
the selected columns by default for an RPC event.
Actually, I seem to recall having made the same observation as Anand.
If I have a server-side trace, and open it in Profiler, TextData is
missing for some RPC events, although it's returned by fn_trace_gettable.
It was a while since I ran into this, but it may be that if I include
BinaryData in the trace, this does not happen.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 7 of 7 < 1 2 3 4 5 6 7

« 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