SQL Server Errors or Failures from Error: 6104 to Error: 6203

SQLServerF1

 

Error: 6104, Severity: 16, Cannot use KILL to kill your own process.
Error: 6106, Severity: 16, Process ID %d is not an active process ID.
Error: 6107, Severity: 14, Only user processes can be killed.
Error: 6108, Severity: 16, KILL SPID WITH COMMIT/ROLLBACK is not supported by Microsoft SQL Server. Use KILL UOW WITH COMMIT/ROLLBACK to resolve in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC).
Error: 6109, Severity: 10, SPID %d: transaction rollback in progress. Estimated rollback completion: %d%%. Estimated time remaining: %d seconds.
Error: 6110, Severity: 16, The distributed transaction with UOW %s does not exist.

Error: 6111, Severity: 16, Another user has decided a different outcome for the distributed transaction associated with UOW %s.
Error: 6112, Severity: 16, Distributed transaction with UOW %s is in prepared state. Only Microsoft Distributed Transaction Coordinator can resolve this transaction. KILL command failed.
Error: 6113, Severity: 16, The distributed transaction associated with UOW %s is in PREPARE state. Use KILL UOW WITH COMMIT/ROLLBACK syntax to kill the transaction instead.
Error: 6114, Severity: 16, Distributed transaction with UOW %s is being used by another user. KILL command failed.
Error: 6115, Severity: 16, KILL command cannot be used inside user transactions.
Error: 6117, Severity: 16, There is a connection associated with the distributed transaction with UOW %s. First, kill the connection using KILL SPID syntax.

Error: 6118, Severity: 16, The distributed transaction associated with UOW %s is not in PREPARED state. Use KILL UOW to kill the transaction instead.
Error: 6119, Severity: 10, Distributed transaction with UOW %s is rolling back: estimated rollback completion: %d%%, estimated time left %d seconds.
Error: 6120, Severity: 16, Status report cannot be obtained. Rollback operation for Process ID %d is not in progress.
Error: 6121, Severity: 16, Status report cannot be obtained. Rollback operation for UOW %s is not in progress.
Error: 6200, Severity: 16, Method “%ls” of type “%ls” in assembly “%.*ls” is marked as a mutator. Mutators cannot be used in the read-only portion of the query.
Error: 6201, Severity: 16, Method “%ls” of type “%ls” in assembly “%.*ls” is not marked as a mutator. Only mutators can be used to update the value of a CLR type.
Error: 6202, Severity: 16, Method “%ls” of type “%ls” in assembly “%.*ls” does not return a value.
Error: 6203, Severity: 16, Method ‘%ls’ of type ‘%ls’ in assembly ‘%.*ls’ cannot be marked as a mutator. A mutator method must be non-static, public, and returns void type.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *