Category: SQL Server

SQL Server Error Code – 8539 the distributed transaction with uow %ls

In this blog post, you’ll learn more about the SQL Server Error Code 8539 and the error message description that is shown SQL Server Error Code 8539 SQL Server Error Description for the Code :8539 The distributed transaction with UOW %ls was forced to commit. MS DTC became temporarily unavailable and forced heuristic resolution of the transaction. This is an informational message only. No user…

SQL Server Error Code – 21064 the subscription is uninitialized or una

In this blog post, you’ll learn more about the SQL Server Error Code 21064 and the error message description that is shown SQL Server Error Code 21064 SQL Server Error Description for the Code :21064 The subscription is uninitialized or unavailable for immediate updating as it is marked for reinitialization. If using queued failover option, run Queue Reader Agent for subscription initialization. Try again after…

SQL Server Error Code – 929 unable to close a database that is not c

In this blog post, you’ll learn more about the SQL Server Error Code 929 and the error message description that is shown SQL Server Error Code 929 SQL Server Error Description for the Code :929 Unable to close a database that is not currently open. The application should reconnect and try again. If this action does not correct the problem, contact your primary support provider.

SQL Server Error Code – 5279 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 5279 and the error message description that is shown SQL Server Error Code 5279 SQL Server Error Description for the Code :5279 Table error: object ID %d, index ID %d, partition ID %I64d, database fragment ID %d. The row on page (%d:%d), slot ID %d should be on fragment ID %d but…

SQL Server Error Code – 1732 cannot create the sparse column set ?%.*

In this blog post, you’ll learn more about the SQL Server Error Code 1732 and the error message description that is shown SQL Server Error Code 1732 SQL Server Error Description for the Code :1732 Cannot create the sparse column set ?%.*ls? in the table ?%.*ls? because a table cannot have more than one sparse column set. Modify the statement so that only one column…