Category: SQL Server
SQL Server Error Code – 40581 logically filtered secondaries are only
In this blog post, you’ll learn more about the SQL Server Error Code 40581 and the error message description that is shown SQL Server Error Code 40581 SQL Server Error Description for the Code :40581 Logically filtered secondaries are only supported if the secondary is a forwarder.
SQL Server Error Code – 8517 failed to get microsoft distributed tran
In this blog post, you’ll learn more about the SQL Server Error Code 8517 and the error message description that is shown SQL Server Error Code 8517 SQL Server Error Description for the Code :8517 Failed to get Microsoft Distributed Transaction Coordinator (MS DTC) PREPARE information: %ls.
SQL Server Error Code – 14396 only members of sysadmin server role can
In this blog post, you’ll learn more about the SQL Server Error Code 14396 and the error message description that is shown SQL Server Error Code 14396 SQL Server Error Description for the Code :14396 Only members of sysadmin server role can modify multi-server jobs
SQL Server Error Code – 25720 ‘sys.fn_xe_file_target_read_file’ is ski
In this blog post, you’ll learn more about the SQL Server Error Code 25720 and the error message description that is shown SQL Server Error Code 25720 SQL Server Error Description for the Code :25720 ‘sys.fn_xe_file_target_read_file’ is skipping records from “%.*ls” at offset %I64d.
SQL Server Error Code – 35301 the statement failed because a columnsto
In this blog post, you’ll learn more about the SQL Server Error Code 35301 and the error message description that is shown SQL Server Error Code 35301 SQL Server Error Description for the Code :35301 The statement failed because a columnstore index cannot be unique. Create the columnstore index without the UNIQUE keyword or create a unique index without the COLUMNSTORE keyword.
SQL Server Error Code – 4345 problems recording information in the ms
In this blog post, you’ll learn more about the SQL Server Error Code 4345 and the error message description that is shown SQL Server Error Code 4345 SQL Server Error Description for the Code :4345 Problems recording information in the msdb..suspect_pages table were encountered. This error does not interfere with any activity except maintenance of the suspect_pages table. Check the error log for more information.
SQL Server Error Code – 5261 %.*ls: page %d:%d could not be moved bec
In this blog post, you’ll learn more about the SQL Server Error Code 5261 and the error message description that is shown SQL Server Error Code 5261 SQL Server Error Description for the Code :5261 %.*ls: Page %d:%d could not be moved because it has not been formatted.
SQL Server Error Code – 2560 parameter %d is incorrect for this dbcc
In this blog post, you’ll learn more about the SQL Server Error Code 2560 and the error message description that is shown SQL Server Error Code 2560 SQL Server Error Description for the Code :2560 Parameter %d is incorrect for this DBCC statement.
SQL Server Error Code – 9696 cannot start the service broker primary
In this blog post, you’ll learn more about the SQL Server Error Code 9696 and the error message description that is shown SQL Server Error Code 9696 SQL Server Error Description for the Code :9696 Cannot start the Service Broker primary event handler. This error is a symptom of another problem. Check the SQL Server error log for additional messages, and address this underlying problem.
SQL Server Error Code – 20021 the subscription could not be found.
In this blog post, you’ll learn more about the SQL Server Error Code 20021 and the error message description that is shown SQL Server Error Code 20021 SQL Server Error Description for the Code :20021 The subscription could not be found.
SQL Server Error Code – 20609 cannot attach subscription file ‘%s’. ma
In this blog post, you’ll learn more about the SQL Server Error Code 20609 and the error message description that is shown SQL Server Error Code 20609 SQL Server Error Description for the Code :20609 Cannot attach subscription file ‘%s’. Make sure that it is a valid subscription copy file.
SQL Server Error Code – 40312 inconsistent index build state.
In this blog post, you’ll learn more about the SQL Server Error Code 40312 and the error message description that is shown SQL Server Error Code 40312 SQL Server Error Description for the Code :40312 Inconsistent index build state.
SQL Server Error Code – 47041 reason: login failed because login token
In this blog post, you’ll learn more about the SQL Server Error Code 47041 and the error message description that is shown SQL Server Error Code 47041 SQL Server Error Description for the Code :47041 Reason: Login failed because login token feature extension is not present.
SQL Server Error Code – 1737 duplicate distribution clause specified
In this blog post, you’ll learn more about the SQL Server Error Code 1737 and the error message description that is shown SQL Server Error Code 1737 SQL Server Error Description for the Code :1737 Duplicate distribution clause specified for the table being created. Remove one of the distribution clauses and resubmit the request.
SQL Server Error Code – 8693 cannot compile query because combination
In this blog post, you’ll learn more about the SQL Server Error Code 8693 and the error message description that is shown SQL Server Error Code 8693 SQL Server Error Description for the Code :8693 Cannot compile query because combination of LogicalOp = ‘%ls’, PhysicalOp = ‘%ls’, and sub_element = ‘%ls’ under RelOp element in XML plan in USE PLAN hint is not valid. Use…
SQL Server Error Code – 21811 cannot drop the column ‘%s’ because it i
In this blog post, you’ll learn more about the SQL Server Error Code 21811 and the error message description that is shown SQL Server Error Code 21811 SQL Server Error Description for the Code :21811 Cannot drop the column ‘%s’ because it is used by replication: it is referenced in a filter or view by article ‘%s’. To drop the column, you must first remove…
SQL Server Error Code – 41198 the availability_mode option has not bee
In this blog post, you’ll learn more about the SQL Server Error Code 41198 and the error message description that is shown SQL Server Error Code 41198 SQL Server Error Description for the Code :41198 The AVAILABILITY_MODE option has not been specified for the replica ‘%.*ls’. Reenter the command, specifying an availability mode for the replica.
SQL Server Error Code – 4083 the connection was recovered and rowcoun
In this blog post, you’ll learn more about the SQL Server Error Code 4083 and the error message description that is shown SQL Server Error Code 4083 SQL Server Error Description for the Code :4083 The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount.
SQL Server Error Code – 14802 cannot disable remote_data_archive becau
In this blog post, you’ll learn more about the SQL Server Error Code 14802 and the error message description that is shown SQL Server Error Code 14802 SQL Server Error Description for the Code :14802 Cannot disable REMOTE_DATA_ARCHIVE because the database contains at least one table having REMOTE_DATA_ARCHIVE enabled.
SQL Server Error Code – 17049 unable to cycle error log file from ‘%ls
In this blog post, you’ll learn more about the SQL Server Error Code 17049 and the error message description that is shown SQL Server Error Code 17049 SQL Server Error Description for the Code :17049 Unable to cycle error log file from ‘%ls’ to ‘%ls’ due to OS error ‘%s’. A process outside of SQL Server may be preventing SQL Server from reading the files….