Category: SQL Server

SQL Server Error Code – 21541 cannot complete alter table command. do

In this blog post, you’ll learn more about the SQL Server Error Code 21541 and the error message description that is shown SQL Server Error Code 21541 SQL Server Error Description for the Code :21541 Cannot complete ALTER TABLE command. Do not execute the command ‘ALTER TABLE table_name DISABLE TRIGGER ALL’ on a published table. Reissue multiple ‘ALTER TABLE table_name DISABLE TRIGGER trigger_name’ statements to…

SQL Server Error Code – 41850 memory optimized segment table consisten

In this blog post, you’ll learn more about the SQL Server Error Code 41850 and the error message description that is shown SQL Server Error Code 41850 SQL Server Error Description for the Code :41850 Memory optimized segment table consistency error detected. Segments are not well formed for Segment CkptId = %I64d, LsnInfo = (%I64d:%hu), TxBegin = %I64d, TxEnd = %I64d.

SQL Server Error Code – 8695 cannot execute query because of incorrec

In this blog post, you’ll learn more about the SQL Server Error Code 8695 and the error message description that is shown SQL Server Error Code 8695 SQL Server Error Description for the Code :8695 Cannot execute query because of incorrectly formed XML plan in USE PLAN hint. Verify that XML plan is a legal plan suitable for plan forcing. See Books Online for additional…

SQL Server Error Code – 7405 heterogeneous queries require the ansi_n

In this blog post, you’ll learn more about the SQL Server Error Code 7405 and the error message description that is shown SQL Server Error Code 7405 SQL Server Error Description for the Code :7405 Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

SQL Server Error Code – 22515 the publication cannot use precomputed p

In this blog post, you’ll learn more about the SQL Server Error Code 22515 and the error message description that is shown SQL Server Error Code 22515 SQL Server Error Description for the Code :22515 The publication cannot use precomputed partitions because there is at least one circular reference in the join filters specified for the articles in the publication. To use precomputed partitions, ensure…