Category: SQL Server

SQL Server Error Code – 21783 cannot add the publisher triggers and th

In this blog post, you’ll learn more about the SQL Server Error Code 21783 and the error message description that is shown SQL Server Error Code 21783 SQL Server Error Description for the Code :21783 Cannot add the Publisher triggers and the article log table to the Oracle Publisher for the article ‘%s’. Verify connection information and ensure that you can connect to the Publisher…

SQL Server Error Code – 35387 tempdb ran out of space during spilling.

In this blog post, you’ll learn more about the SQL Server Error Code 35387 and the error message description that is shown SQL Server Error Code 35387 SQL Server Error Description for the Code :35387 TEMPDB ran out of space during spilling. Verify that data is evenly distributed and/or rewrite the query to consume fewer rows. If the issue still persists, consider upgrading to a…

SQL Server Error Code – 9728 cannot find the security certificate bec

In this blog post, you’ll learn more about the SQL Server Error Code 9728 and the error message description that is shown SQL Server Error Code 9728 SQL Server Error Description for the Code :9728 Cannot find the security certificate because the lookup database principal ID (%i) is not valid. The security principal may have been dropped after the conversation was created.

SQL Server Error Code – 6842 could not serialize the data for node ‘%

In this blog post, you’ll learn more about the SQL Server Error Code 6842 and the error message description that is shown SQL Server Error Code 6842 SQL Server Error Description for the Code :6842 Could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data convert it to binary, varbinary or…

SQL Server Error Code – 33117 transparent data encryption is not avail

In this blog post, you’ll learn more about the SQL Server Error Code 33117 and the error message description that is shown SQL Server Error Code 33117 SQL Server Error Description for the Code :33117 Transparent Data Encryption is not available in the edition of this SQL Server instance. See books online for more details on feature support in different SQL Server editions.

SQL Server Error Code – 41420 at least one availability database on th

In this blog post, you’ll learn more about the SQL Server Error Code 41420 and the error message description that is shown SQL Server Error Code 41420 SQL Server Error Description for the Code :41420 At least one availability database on this availability replica has an unhealthy data synchronization state. If this is an asynchronous-commit availability replica, all availability databases should be in the SYNCHRONIZING…