Post reply

Import file trace into database

  • December 8, 2005 at 2:33 am

    #90168

    Hi,

    Do you know a script (DMO or ohter) to import SQL 7.0 traces generated by SQL Profiler in another SQLSERVER or ORACLE database ?

    Regards

  • December 8, 2005 at 6:02 am

    #608386

    I'm not sure if this will work in SQL Server 7, but the way I do it in 2000 is:

    SELECT TextData,NTUserName,HostName,ApplicationName,LoginName

    FROM ::fn_trace_gettable(@TraceFile, default)

    @TraceFile would be the physical location of the trace file, and you can specify any of the fields you are capturing in your trace file in the SELECT clause.

     

     

     

  • December 8, 2005 at 6:36 am

    #608394

    Sorry I know this command but it doesn't work for SQL SERVER 7.0

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

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