RE: SQLtrace

RE: SQLtrace

 

  

ive never seen this before, what trace flags have you set? and where did it
come from??

-----Original Message-----
From: Shelly Wu [mailto:[Email Address Removed] Thursday, 25 July 2002 12:29 AM
To: SQLDBA (E-mail)
Subject: SQLtrace


Hi all,

Is anyone know how to read SQltrace file?
my screen script is like following:

-- The start time of this event is unknown. Active connections (ID=29,
SPID=27, User=RECOVER(\), App='', Host=''(4a4) )
-- 7/24/2002 12:21:40.630 Disconnection (ID=29, SPID=27, User=RECOVER(\),
App='', Host=''(4a4) )
-- The start time of this event is unknown. Active connections (ID=30,
SPID=27, User=RECOVER(\), App='', Host=''(4a4) )
-- 7/24/2002 12:21:41.116 Disconnection (ID=30, SPID=27, User=RECOVER(\),
App='', Host=''(4a4) )
-- The start time of this event is unknown. Active connections (ID=31,
SPID=27, User=RECOVER(\), App='', Host=''(1d8) )
-- 7/24/2002 12:21:41.333 Disconnection (ID=31, SPID=27, User=RECOVER(\),
App='', Host=''(1d8) )
-- The start time of this event is unknown. Active connections (ID=32,
SPID=27, User=RECOVER(\), App='', Host=''(4a4) )
-- 7/24/2002 12:21:41.553 Disconnection (ID=32, SPID=27, User=RECOVER(\),
App='', Host=''(4a4) )
-- The start time of this event is unknown. Active connections (ID=33,
SPID=27, User=RECOVER(\), App='', Host=''(1d8) )
-- 7/24/2002 12:21:41.773 Disconnection (ID=33, SPID=27, User=RECOVER(\),
App='', Host=''(1d8) )

-----

Host=''(4a4),host=''(1d8).what is 4a4 and 1d8 stand for.

thanks

Shelly


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page