Import file trace into database

• Samx

  Ten Centuries

  Points: 1021

  More actions

  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

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  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.

   

   

   

• Samx

  Ten Centuries

  Points: 1021

  More actions

  December 8, 2005 at 6:36 am

  #608394

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