Re: Trace File with null time SQL2000

Munish Narula (munish.narula@xxxxxxxxx) writes:
In SQL 2000, i have enabled C2 audit. In the trace file generated, i can
see an event with eventclass 17 (ExistingConnection), which has
starttime and endtime as null. This does not happen in SQL2005.

I just wanted to check if it is a bug in SQL 2000 or this is the expected
behaviour.

Tne ExistingConnection is not documented to populate neither StartTime
nor EndTime in SQL 2000, and indeed when I start a standard trace, there
is no data in these columns. There are on SQL 2005.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Trace File with null time SQL2000
    ... which do not have endtime, but have starttime. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Profiler: Duration vs Difference between StartTime and EndTime
    ... I am not certain how duration is calculated, but I regularly see numbers that are wildly inaccurate. ... "Expert SQL Server 2005 Development" ... The duration for some of the statements was just under 1 minute, however for the same statements the difference between the starttime and endtime were closer to 17 ms. ...
    (microsoft.public.sqlserver.tools)
  • Obtaining Stored Procedure Parameters
    ... I am trying to execute a (SQL Server 2000) stored procedure as follows: ... SPRoc.Connection:= ExistingConnection; ... I would like to obtain and bind the parameter definitions from the SQL ...
    (borland.public.delphi.database.ado)