Dinesh Priyankara (7/24/2003)

---

<font face='Verdana'>

Ok. What I want is : create a trace using sp_trace_create with option 2. That's what I have done. But I cannot read the tracefile untill I stop and restart the server. I am getting an error when I call fn_trace_gettable function.

<b>

SELECT * FROM :: fn_trace_gettable (N'E:\Traces\monitor.trc', 1)

Output:

Server: Msg 567, Level 16, State 2, Line 1

File 'E:\Traces\monitor.trc' either does not exist or is not a recognizable trace file. Or there was an error opening the file.[/b]

As per microsoft site http://support.microsoft.com/support/kb/articles/q273/9/72.asp , This is bug. And they have given a workaround but no luck.

I highly appreciate if you can help me on this.

Dinesh

</font id='Verdana'>

MCP MCSE MCSD MCDBA