Hi All,

I am trying to create AS trace file programatically. I am using following
code:

            TraceServer reader = new TraceServer();
            TraceFile writer = new TraceFile();
            OlapConnectionInfo olapConn = new OlapConnectionInfo();
            olapConn.ServerName = "ABC";
            olapConn.DatabaseName = "XYZ";
            olapConn.UseIntegratedSecurity = true;
            reader.InitializeAsReader(olapConn, "C:\\MDX.tdf");
            writer.InitializeAsWriter(reader, "C:\\NewTrace.trc");
            .... calling function which decides till when we need to capture
trace
           writer.Close();

The result is that I get a blank trace file at "C:\NewTrace.trc". I have
verified that reader has data. What am I doing wrong?

Is there any otherway to write the trace data to a file?

Thanks,
Sourabh

SQL 2k5 vs 2k - different results on same execution? ORDER BY prob
What is this called, and how to do it?
SQL Server vs the Competition
Select Records which are not present in second table
Retreiving multiple Output Parameters