Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

sql profiler- text data is empty

User generated image
I just wondering, why text data is missing althought event class have got something.
Avatar of jogos
jogos
Flag of Belgium image

Do you never see textdata or only for a series of records?
What's your sql-version? And the compatibility-level of your database? And this ofcourse on the moment the trace was made (may).


For SQL2000 there is an issue
http://support.microsoft.com/kb/892028
Avatar of motioneye

ASKER

its only on series of records, we running sql2005 with SP4 and the compatibility of course  90. I just wondering why I can't see text data although event class explicitly appear as "SQL:StmntCompleted"
Below what is being capttured in sql profiler for event class: SQL:StmntCompleted

EXEC sp_trace_setevent @trId, 41, 1, @on
EXEC sp_trace_setevent @trId, 41, 6, @on
EXEC sp_trace_setevent @trId, 41, 11, @on
EXEC sp_trace_setevent @trId, 41, 8, @on
EXEC sp_trace_setevent @trId, 41, 14, @on
EXEC sp_trace_setevent @trId, 41, 15, @on
EXEC sp_trace_setevent @trId, 41, 13, @on
EXEC sp_trace_setevent @trId, 41, 18, @on
EXEC sp_trace_setevent @trId, 41, 35, @on
EXEC sp_trace_setevent @trId, 41, 3, @on
Hi,
I found it... it because os sp_change_users_login sp, but why it was logged under eventclass SQL:StmntCompleted ? which I believe this suppose to be SP:StmntCompleted
ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I able to resolve my self, at least you giving me some hint with your answer :)
What was your solution. Would you like to share with us?