Accessing active trace in SQL Server 2000 generates exception

• elitejyo

  Valued Member

  Points: 61

  More actions

  February 5, 2009 at 2:46 am

  #383874

  When I try to read an active trace using the query :

  SELECT TOP 1000 * FROM ::fn_trace_gettable('d:\traces\delay.trc', 1)

  I get this exception:

  com.microsoft.sqlserver.jdbc.SQLServerException: Server encountered an error 'd:\traces\delay.trc'.

  It keeps throwing this exception a few times and then starts reading the file w/o any problem.

  I have posted this problem at many forums and all they have to say is that the active trace file gets locked and hence the exception. But my question is that why are we sometimes able to access the trace even though it is still active.

  I would highly appreciate if someone can help me out in this. It would be nice if you can give reference to any Microsoft's documentation which referes to SQL server 2000 's behavior in this regards.

  Thanks in advance,

  Jyoti

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 5, 2009 at 7:07 am

  #938815

  Here are a couple of links that may help you:

  http://support.microsoft.com/default.aspx/kb/325197

  http://support.microsoft.com/kb/273972

  It sounds like the second one may be more like your issue.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question