Reading Trace file using VB Script

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  December 27, 2005 at 9:05 pm

  #166372

  Hi all,

   

  Is there anyway to read the trace file using vb script ?

  can anybody help me to do this ?

  
  subban

• Keith Platter

  Newbie

  Points: 5

  More actions

  December 29, 2005 at 8:37 am

  #611925

  Here is an example script that may do what you need.  It uses an adodb connection and resultset object, and the sql function fn_trace_gettable.

  Dim adoConn

  Set adoConn = CreateObject("ADODB.Connection")

  Dim adoRs

  Set adoRs = CreateObject("ADODB.Recordset")

  sConn = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=Master;Trusted_Connection=yes;"

  adoConn.ConnectionString = sConn

  adoConn.Open

  Set adoRs = adoConn.Execute("SELECT * FROM ::fn_trace_gettable('C:\temp\trace1.trc', default)")

  While not adoRs.Eof

   wscript.echo "" & adors("loginname")

   adoRs.Movenext

  Wend

  adoRs.Close

  adoConn.Close

  Hope this helps.