Debugging a failed transaction, I asked the DBA to run a trace on SQL Server. Eventually he send me a
I use the
fn_tracegettable() function to access the trace:
select * from sys.fn_trace_gettable('C:\path\to\myTraceFile.trc', default)
But I get the following error:
Msg 567, Level 16, State 7, Line 1 File 'C:\path\to\myTraceFile.trc' either does not exist or is not a recognizable trace file. Or there was an error opening the file.
- The SQL Management Studio I am executing the
fn_tracegettablefrom runs in my local machine.
- The .trc file is in my local machine.
- Both the server and the local machine run a SQL Server 2008 R2.