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 |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2011-01-12 : 04:48:41
|
| Hi Everyone,I got a problem and need your help. I'm now using profiler to do some tracing. As we know, when we create a new trace, in Event Selection Tab, we can use "Column Filters" button to do some filterings. Now I put some keyword(egs, %customer_name%) in "Text Data" column as a filter which means Profiler will record all the Sql Scripts which contain the keyword "customer_name". But what shall I do if i need more than one keyword(egs, address) in "Text Data" column. I have tried format like %customer_name% or %address%, or %customer_name%, %address%, but that doesn't work. Can somebody give me some hints? Thanks very much.regards,Oliver |
|
|
mandm
Posting Yak Master
120 Posts |
Posted - 2011-01-14 : 16:46:24
|
| Your best bet is probably to save the trace results to a table in a database. Then you can run SQL queries against it. |
 |
|
|
|
|
|
trace using Sql Server Profiler