Sessions Data Columns

Administering SQL Server

Administering SQL Server

Sessions Data Columns

The following table lists the data columns for each event class in the Sessions event category.

Event class Data column Description
Existing Connection Event Class Type of event recorded = 17.
  Binary Data Session level settings, including ANSI nulls, ANSI padding, cursor close on commit, null concatenation, and quoted identifiers. For more information, see SET.

In addition to the data columns that are specific to the Existing Connection event class, by monitoring the DBUserName and NT User Name default data columns, you can map the name of the user to each connection.

See Also

Sessions Event Category

Sessions Event Classes