Category: SQL Server

SQL Server Error Code – 21844 can not alter xml, clr type or max type

In this blog post, you’ll learn more about the SQL Server Error Code 21844 and the error message description that is shown SQL Server Error Code 21844 SQL Server Error Description for the Code :21844 Can not alter XML, CLR type or MAX type column because table is published and article ‘%s’ supports the schema option to map this to a base column type.

SQL Server Error Code – 21754 processing has been terminated. the resu

In this blog post, you’ll learn more about the SQL Server Error Code 21754 and the error message description that is shown SQL Server Error Code 21754 SQL Server Error Description for the Code :21754 Processing has been terminated. The resultset for sp_getqueuedrows is larger than 16,000, the maximum size that the procedure can return. Run the Queue Reader Agent to flush the queue at…

SQL Server Error Code – 8562 the connection has been lost with micros

In this blog post, you’ll learn more about the SQL Server Error Code 8562 and the error message description that is shown SQL Server Error Code 8562 SQL Server Error Description for the Code :8562 The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection…

SQL Server Error Code – 35204 the connection between server instances

In this blog post, you’ll learn more about the SQL Server Error Code 35204 and the error message description that is shown SQL Server Error Code 35204 SQL Server Error Description for the Code :35204 The connection between server instances ‘%ls’ with id [%ls] and ‘%ls’ with id [%ls] has been disabled because the database mirroring endpoint was either disabled or stopped. Restart the endpoint…