| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|
Audit Fulltext Event Class |
Audit Fulltext Event Class |
WilliamDAssafMSFT |
wiassaf |
03/14/2017 |
sql |
supportability |
reference |
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] The Audit Fulltext event class occurs when [!INCLUDEssNoVersion] connects to and communicates with the full-text filter daemon process.
| Data column name | Data type | Description | Column ID | Filterable |
|---|---|---|---|---|
| Error | int | The [!INCLUDEssNoVersion] error number, if this event reports an error. | 31 | Yes |
| EventSequence | int | The sequence of a given event within the request. | 51 | No |
| EventSubClass | int | Type of connection used by the login. 1 = Nonpooled, 2 = Pooled. | 21 | Yes |
| IsSystem | int | Indicates whether the event occurred on a system process or a user process. 1 = system, 0 = user. | 60 | Yes |
| SessionLoginName | nvarchar | Login name of the user who originated the session. For example, if you connect to [!INCLUDEssNoVersion] using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both [!INCLUDEssNoVersion] and Windows logins. | 64 | Yes |
| SPID | int | ID of the session on which the event occurred. | 12 | Yes |
| StartTime | datetime | Time at which the event started, if available. | 14 | Yes |
| Success | int | 1 = success. 0 = failure. For example, a value of 1 indicates success of a permissions check and a value of 0 indicates failure of that check. | 23 | Yes |
| TargetLoginName | int | For actions that target a login (for example, adding a new login), the name of the targeted login. | 42 | Yes |
| TargetLoginSid | int | For actions that target a login (for example, adding a new login), the security identification number (SID) of the targeted login. | 43 | Yes |
| TextData | ntext | Text information about the Full-Text event. Typically this field provides information about the connection between the [!INCLUDEssNoVersion] process and the full-text filter daemon process | 1 | Yes |