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 |
|
grevathy
Starting Member
2 Posts |
 Posted - 2006-04-06 : 03:06:12
|
| Hi! I have automated the creation of Profiler traces via via SP_TRACE sp's. It it working fine except when i set two filters for the same column sayexec sp_trace_setfilter @TraceID, 10, 0, 6, N'M%'exec sp_trace_setfilter @TraceID, 10, 0, 6, N'Re%'It doesn't work. Even if i just set these two filters it doen't work.Can anyone help? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-04-07 : 15:51:50
|
| For yuks and grins, see what you get when you set up the trace in Profiler, then generate a SQL script in profiler. What does that give you? |
 |
|
|
grevathy
Starting Member
2 Posts |
Posted - 2006-04-10 : 08:55:59
|
| Thanks. I did try that. Generated the script in profiler and copied that part of the code. It doesn't seem to work. |
|
|
|
|
|
|
Setting trace set filters