there is a specific sql error that happens few times a week.. (maybe one error every other day.. there is no pattern of when the error happens)..
I need to catch the exact process causing the error without overwhelming the profile process...
I don't know when I will see the same error again on the error log.. so if can capture all entries, I am going to capture 100s of 1000s of records in profiler.
if you knew the error number that you are after, how would you go about pinpointing the code that caused it? (if you did not know when it will occur nextx or which database etc)