I have a trace that is watching for filtered values on the event SQL:StmtCompleted
The following columns have been chosen to be returned in myu result set.
ApplicationName
DatabaseID
NTUserName
NTDomainName
LoginName
Duration
HostName
TextData
SPID
StartTime
EndTime
Success
I am having trouble with the Success and DatabaseName columns. No data comes back in these columns. I have attempted many different configurations, even different events, and they do not come back.
I have another set of traces that i have performed that successfully brings back the success flag. These are in the Audit events though. not in the SQL:StmtCompleted event class...
What am i missing ?