Category: SQL Server

SQL Server Error Code – 11271 a corrupted message has been received. t

In this blog post, you’ll learn more about the SQL Server Error Code 11271 and the error message description that is shown SQL Server Error Code 11271 SQL Server Error Description for the Code :11271 A corrupted message has been received. The conversation ID must not be NULL. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.

SQL Server Error Code – 21756 based on article settings, table %s shou

In this blog post, you’ll learn more about the SQL Server Error Code 21756 and the error message description that is shown SQL Server Error Code 21756 SQL Server Error Description for the Code :21756 Based on article settings, table %s should have an identity column, but it does not have one. Verify article settings with sp_helparticle and change them if necessary with sp_changearticle.

SQL Server Error Code – 30007 parameters of dm_fts_index_keywords, dm_

In this blog post, you’ll learn more about the SQL Server Error Code 30007 and the error message description that is shown SQL Server Error Code 30007 SQL Server Error Description for the Code :30007 Parameters of dm_fts_index_keywords, dm_fts_index_keywords_by_document, dm_fts_index_keywords_by_property, and dm_fts_index_keywords_position_by_document cannot be null.

SQL Server Error Code – 432 xml data type methods are not supported

In this blog post, you’ll learn more about the SQL Server Error Code 432 and the error message description that is shown SQL Server Error Code 432 SQL Server Error Description for the Code :432 Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at…

SQL Server Error Code – 7709 warning: range value list for partition

In this blog post, you’ll learn more about the SQL Server Error Code 7709 and the error message description that is shown SQL Server Error Code 7709 SQL Server Error Description for the Code :7709 Warning: Range value list for partition function ‘%.*ls’ is not sorted by value. Mapping of partitions to filegroups during CREATE PARTITION SCHEME will use the sorted boundary values if the…

SQL Server Error Code – 8663 cannot create the clustered index “%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 8663 and the error message description that is shown SQL Server Error Code 8663 SQL Server Error Description for the Code :8663 Cannot create the clustered index “%.*ls” on view “%.*ls” because its select list does not include COUNT_BIG(*). Consider adding COUNT_BIG(*) to the select list.

SQL Server Error Code – 41038 failed to enumerate windows server failo

In this blog post, you’ll learn more about the SQL Server Error Code 41038 and the error message description that is shown SQL Server Error Code 41038 SQL Server Error Description for the Code :41038 Failed to enumerate Windows Server Failover Clustering (WSFC) objects (Error code %d).  If this is a WSFC availability group, the WSFC service may not be running or may not be…

SQL Server Error Code – 41160 failed to designate the local availabili

In this blog post, you’ll learn more about the SQL Server Error Code 41160 and the error message description that is shown SQL Server Error Code 41160 SQL Server Error Description for the Code :41160 Failed to designate the local availability replica of availability group ‘%.*ls’ as the primary replica.  The operation encountered SQL Server error %d and has been terminated.  Check the preceding error…