Tag: SQL Server Errors

SQL Server Error Msg 21538 – Table ‘%s’ cannot have table ‘%s’ as a parent in a logical record relationship because it already has a different parent table. A logical record relationship allows only one parent table for a given child table.

SQL Server Error Msg 10652 – Refresh of snapshot view failed because ‘%.*ls.%.*ls’ is not a snapshot view.

SQL Server Error Msg 13373 – Anchor record

SQL Server Error Msg 40983 – Replication to the partner managed instance could not be established. Verify that connectivity between the Virtual Networks of the primary and secondary managed servers has been established correctly according to guidelines in https://aka.ms/instanceFailoverGroups.

SQL Server Error Msg 13177 – IL compilation

SQL Server Error Msg 40081 – Cardinality of index should not be less then zero.

SQL Server Error Msg 46610 – SERDE_METHOD

SQL Server Error Msg Cannot create non-clustered index on temporal history table ‘%.*ls’ since it has finite retention period and clustered columnstore index defined. – 13773

SQL Server Error Msg 1460 – The database “%.*ls” is already configured for database mirroring on the remote server. Drop database mirroring on the remote server to establish a new partner.

SQL Server Error Msg 17410 – Automatic soft-NUMA was not enabled, because ‘NodeConfiguration’ key was detected in the registry at path ‘%ls’. Disable registry based soft-NUMA configuration in order to activate the automatic soft-NUMA configuration.

SQL Server Error Msg 41096 – Always On: The local replica of availability group ‘%.*ls’ is being removed. The instance of SQL Server failed to validate the integrity of the availability group configuration in the Windows Server Failover Clustering (WSFC) store.  This is expected if the availability group has been removed from another instance of SQL Server. This is an informational message only. No user action is required.

SQL Server Error Msg 14393 – Only owner of a job or members of role sysadmin or SQLAgentOperatorRole can start and stop the job.

SQL Server Error Msg 20692 – One or more rows to be inserted in the batch insert procedure for table %s were present in MSmerge_tombstone; merge replication cannot use batch insert. This typically occurs when rows move from one partition to another. No action is required, but if this condition occurs frequently, verify that data is partitioned optimally. Batch insert can improve the performance of merge replication.

SQL Server Error Msg 20800 – Cannot reinitialize the article ‘%s’ in subscription ‘%s:%s’ to publication ‘%s’. The publication is enabled for peer-to-peer transactional replication, which does not allow subscriptions to be reinitialized with a snapshot. Drop and re-create the subscription instead.

SQL Server Error Msg 8624 – Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.

SQL Server Error Msg 27303 – An unexpected error with HRESULT 0x%x occurred while processing backup files. Refer to the SQL Server error log for information about any related errors that were encountered. Address those errors if necessary, and retry the operation.

SQL Server Error Msg 46602 – FILE_FORMAT

SQL Server Error Msg 45140 – Maximum lag does not support the specified value. Maximum lag must be between ‘%ls’ and ‘%ls’.

SQL Server Error Msg 28554 – Data Virtualization Manager not found.

SQL Server Error Msg 40198 – Only a primary replica can be configured as a forwarder.