Category: SQL Server

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 – 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 – 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 – 10927 the operation could not be completed.  t

In this blog post, you’ll learn more about the SQL Server Error Code 10927 and the error message description that is shown SQL Server Error Code 10927 SQL Server Error Description for the Code :10927 The operation could not be completed.  The specified ‘%.*ls’ value, %u, causes the sum of minimums on all workload groups using resource pool ‘%.*ls’ to exceed 100 percent. Reduce the…