Post reply

Export Profiler Trace File to Table Automatically

  • October 7, 2003 at 2:11 pm

    #63356

    Hi All,

    I have setup an audit task via stored proc and scheduled as a job. This creates '.trc' files. I then manually save it as a SQL Server table. Is there a way I can automate this process thru DTS or anything.

    Any help is greatly appreciated.

    Thanks

    Pranav

  • October 7, 2003 at 2:39 pm

    #477461

    SELECT * INTO Trace_Table_Name FROM :: fn_trace_gettable('c:\MyTrace.trc', default)

    See BOL for details on fn_trace_gettable function.

  • October 8, 2003 at 7:05 am

    #477532

    Sorry, Allen. I forgot to mention, I have the trace file on SQL 7 and fn_trace_gettable is SQL2000.

    Any fn or SP on SQL7?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply