SQL Server Error : 1206, Severity: 18. The Microsoft Distributed Transaction Co
SQL Server Error : 1206 Details
SQL Server Error: 1206 Severity: 18 Event Logged or not: No Description: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction. Severity 18 Description: Indicates a problem in the Database Engine software, but the statement completes execution, and the connection to the instance of the Database Engine is maintained. The system administrator should be informed every time a message with a severity level of 18 occurs.
Reading sql server error log location from SQL Query
Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read … Read the rest