Category: SQL Server
SQL Server Error Code – 3401 errors occurred during recovery while ro
In this blog post, you’ll learn more about the SQL Server Error Code 3401 and the error message description that is shown SQL Server Error Code 3401 SQL Server Error Description for the Code :3401 Errors occurred during recovery while rolling back a transaction. The transaction was deferred. Restore the bad page or file, and re-run recovery.
SQL Server Error Code – 3992 transaction count has been changed from
In this blog post, you’ll learn more about the SQL Server Error Code 3992 and the error message description that is shown SQL Server Error Code 3992 SQL Server Error Description for the Code :3992 Transaction count has been changed from %d to %d inside of user defined routine, trigger or aggregate ?%.*ls?. This is not allowed and user transaction will be rolled back. Change…
NULLIF function in SQL Server
The NULLIF function in SQL Server returns a NULL value if the two input expressions return the same value else the first value (expression) is returned. For example , assume that you want to compare two columns (Address1 and Address2) in the Address table and want to return NULL if both are same to indicate there is NO change and if the addresses are different…
SQL Server Error Code – 5129 the log cannot be rebuilt when the prima
In this blog post, you’ll learn more about the SQL Server Error Code 5129 and the error message description that is shown SQL Server Error Code 5129 SQL Server Error Description for the Code :5129 The log cannot be rebuilt when the primary file is read-only.
SQL Server Error Code – 28067 a corrupted message has been received. t
In this blog post, you’ll learn more about the SQL Server Error Code 28067 and the error message description that is shown SQL Server Error Code 28067 SQL Server Error Description for the Code :28067 A corrupted message has been received. The encrypted offset of the envelope does not match the payload encrypted offset. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d,…
SQL Server Error Code – 37108 a job account could not be linked to dat
In this blog post, you’ll learn more about the SQL Server Error Code 37108 and the error message description that is shown SQL Server Error Code 37108 SQL Server Error Description for the Code :37108 A job account could not be linked to database ‘%.*ls’ on server ‘%.*ls’ because it is a geo-secondary database.
SQL Server Error Code – 9704 this message could not be delivered beca
In this blog post, you’ll learn more about the SQL Server Error Code 9704 and the error message description that is shown SQL Server Error Code 9704 SQL Server Error Description for the Code :9704 This message could not be delivered because it failed XML validation. This failure occurred while the message was being delivered to the target service.
SQL Server Error Code – 15806 statement id: %s | query hash: %s | dist
In this blog post, you’ll learn more about the SQL Server Error Code 15806 and the error message description that is shown SQL Server Error Code 15806 SQL Server Error Description for the Code :15806 Statement ID: %s | Query hash: %s | Distributed request ID: %s
SQL Server Error Code – 9673 activation has been disabled on the queu
In this blog post, you’ll learn more about the SQL Server Error Code 9673 and the error message description that is shown SQL Server Error Code 9673 SQL Server Error Description for the Code :9673 Activation has been disabled on the queue with ID %d.
SQL Server Error Code – 17179 sql server detected %d sockets with %d c
In this blog post, you’ll learn more about the SQL Server Error Code 17179 and the error message description that is shown SQL Server Error Code 17179 SQL Server Error Description for the Code :17179 SQL Server detected %d sockets with %d cores per socket and %d logical processors per socket, %d total logical processors; using %d logical processors based on SQL Server licensing.
SQL Server Error Code – 33314 the supplied whitelist is invalid.
In this blog post, you’ll learn more about the SQL Server Error Code 33314 and the error message description that is shown SQL Server Error Code 33314 SQL Server Error Description for the Code :33314 The supplied whitelist is invalid.
SQL Server Error Code – 37201 an instance pool could not be found with
In this blog post, you’ll learn more about the SQL Server Error Code 37201 and the error message description that is shown SQL Server Error Code 37201 SQL Server Error Description for the Code :37201 An instance pool could not be found with name ‘%.*ls’.