Re: Trace File with null time SQL2000
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 14 Mar 2008 15:51:47 -0700
Munish Narula (munish.narula@xxxxxxxxx) writes:
I was just wondering as to how many more events are there which do not
have starttime AND endtime values. I know there are a lot of events
which do not have endtime, but have starttime. But, is
ExistingConnection, the only one of its kind having both starttime and
endtime as null.
On SQL 2005 you can determine this with help of this query.
SELECT *
FROM sys.trace_events e
WHERE NOT EXISTS
(SELECT *
FROM sys.trace_event_bindings eb
JOIN sys.trace_columns c
ON eb.trace_column_id = c.trace_column_id
WHERE e.trace_event_id = eb.trace_event_id
AND c.name IN ('StartTime', 'EndTime'))
It returns one single event: Deprecated.
One more event does not have a start time: Blocked Process Report.
For SQL 2000, the only way to find out is to read Books Online and hope that
the documentation is correct.
--
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
.
- References:
- Re: Trace File with null time SQL2000
- From: Erland Sommarskog
- Re: Trace File with null time SQL2000
- Prev by Date: Connecting to linked SQL table in Access
- Next by Date: Re: Connecting to linked SQL table in Access
- Previous by thread: Re: Trace File with null time SQL2000
- Next by thread: Connecting to linked SQL table in Access
- Index(es):
Relevant Pages
|
