I'm replaying a trace in Profiler, and I'd like to only see the Provider Errors. Granted, there are ~30,000 of them but I'm not concerned at the moment about row update conflicts, foreign key or unique index issues.
Currently, I'm output the trace from the replay to file. I've tried creating a table from the result trace file, but either I'm missing something or the Provider Errors are not being imported into the table:
SELECT * INTO MyTraceTemp FROM ::fn_trace_gettable('c:\x\MyTrace.trc', default)
This is using Profiler against SQL Server 2008R2, if that matters.