Trace File Close Event Class


Applies To: SQL Server 2016

The Trace File Close event class indicates that a trace file has been closed during a trace file rollover.

Data column nameData typeDescriptionColumn IDFilterable
EventClassintType of event = 150.27No
EventSequenceintThe unique timestamp of this event fired in this trace. This number increases monotonically for each event fired.51No
FileNamenvarcharThe logical name of the trace file being closed.36Yes
IsSystemintIndicates whether the event occurred on a system process or a user process. 1 = system, NULL = user. The value is always 1 for this event class.60Yes
LoginNamenvarcharName of the login of the user (either SQL Server security login or the Microsoft Windows login credentials in the form of DOMAIN\username). The value is always "sa" for this event class.11Yes
ObjectIDintSystem-assigned ID of the trace.22Yes
ServerNamenvarcharName of the instance of SQL Server being traced.26No
SessionLoginNamenvarcharLogin name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Windows logins.64Yes
SPIDintID of the session on which the event occurred.12Yes
StartTimedatetimeTime at which the event started, if available.14Yes

sp_trace_setevent (Transact-SQL)

Community Additions