September 17, 2009 at 1:03 pm
I have a server side trace running, and now want to utilize it to track down some data changes.
I go into Trace File properties -> Column Filters -> and set TEXTDATA LIKE 'MyField'
When I rerun it, I get results of changes I made earlier with an update statement. Good
Then I do TEXTDATA LIKE 'StoredProcedure_Name' of a stored procedure that updates the field, I get results, but TextData is blank in the results. The results are of a developer's Query Analyzer session, and she's not running that SP.
Why would I get results with blank TEXTDATA when I'm entering a specific value ?
If I set TEXTDATA like Update MyTable, I get a mix of valid rows, and more rows with blank TEXTDATA
What am I doing wrong (this time !)
September 18, 2009 at 4:48 am
Try adding % before and after the proc name.
Also, sometime I find after typing the filter I have to press otherwise the profiler doesnt apply the filter! Strange!!!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply