Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
 Posted - 2008-12-26 : 09:56:35
|
| I am trying to filter the output of SQL Profiler(SQL 2005) on the TextData column using the Like clause. (In Trace Properties->Events Selection--> Column Filters -> Text Data) But the filter doesn't seem to work for me.For example, I want to get only queries that have the word UPDATE in it. I tried various combinations like:UPDATE%UPDATE%'%UPDATE%'and so on in the Like clause.Regardless of what I tried, the profiler spits out all queries that it finds whether or not there is an UPDATE in the Text Data column of the output.What might I be doing wrong?Sunita |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-26 : 17:14:19
|
| I am able to get only udate queries with Filter-Textdata- LIKE - Update %. |
 |
|
|
|
|
|
Filtering TextData in SQL Profiler