Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unable to see entire SQL Statement in profiler Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 12:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:11 AM
Points: 336, Visits: 1,155
I ran profiler but the column textdata does not give me the entire sql statement.

What is the reason?

how to export entire textdata column?

i did 2 way

1)
CREATE TABLE TraceResults (
TextData VARCHAR(4000),
Duration INT,
Reads INT,
Writes INT,
CPU INT,
StartTime DATETIME,
EndTime DATETIME,
ProcedureName VARCHAR(100)
)

Insert into TraceResults
SELECT TextData, Duration, Reads, Writes, CPU, StartTime,EndTime
FROM ::fn_trace_gettable('E:\tracename.trc',1)

2) Open the trace file and save as Trace Table

both did not gave me the entire Textdata. how can i get it, it limiting by 256 bytes
Post #1568287
Posted Wednesday, May 7, 2014 3:41 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 2,302, Visits: 2,773
yuvipoy (5/7/2014)
.....both did not gave me the entire Textdata. how can i get it, it limiting by 256 bytes


This could be the default limit in SSMS. Look in SSMS for the "properties" option in the "tools" menu. Expand the tree for "Query results" and check the settings in the "results to grid" and "results to text".


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1568345
Posted Wednesday, May 7, 2014 5:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:11 AM
Points: 336, Visits: 1,155
HanShi (5/7/2014)
yuvipoy (5/7/2014)
.....both did not gave me the entire Textdata. how can i get it, it limiting by 256 bytes


This could be the default limit in SSMS. Look in SSMS for the "properties" option in the "tools" menu. Expand the tree for "Query results" and check the settings in the "results to grid" and "results to text".


I think you entered here wrongly.
It is SQL server 200 it does not have SSMS.
and thats too setting value in SSMS i dont think it will resolve.. in profiler
Post #1568383
Posted Wednesday, May 7, 2014 5:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 5:41 AM
Points: 2, Visits: 3
I'm agree with you mate :)
______________
fast weight loss pills, how to lose weight, slimming pills,cha de bugre


:)
Post #1568386
Posted Wednesday, May 7, 2014 5:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 2,302, Visits: 2,773
yuvipoy (5/7/2014)
I think you entered here wrongly.
It is SQL server 200 it does not have SSMS.
and thats too setting value in SSMS i dont think it will resolve.. in profiler


I'm sorry. I didn't notice this thread was under the SQL2000 forum.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1568391
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse