SQL always maintains a connection-specific counter to count the number of data truncation events occurred during a connection. This number of data truncation events is always logged to the database log file when a connection is disconnected. The counter is initialized to zero when a connection is established with the SQL server.
At the time of disconnect, if the value of this counter is zero, and as a result if there was no data truncation, no information related to the data truncation is written to the database log file. At the time of disconnect, if value of this counter is zero, and as a result if there was no data truncation, no information related to the data truncation is written to the database log file.
The message to the database log file is written in the following format:
<date-time> P-<process-id> T-<thread-id> I SQLSRV2 <server-id> : <counter> authorized data truncation action(s) performed.
