Tag: SQL Server Errors

SQL Server Error Msg 14866 – Attempted unlinking of the stretched table failed. If this table isn’t dropped, please retry the operation of setting REMOTE_DATA_ARCHIVE to OFF on the table.

SQL Server Error Msg 28931 – Configuration manager agent roster is corrupt.

SQL Server Error Msg 5090 – Database ‘%.*ls’ is a system database. Change tracking settings cannot be modified for system databases.

SQL Server Error Msg 6386 – Cannot convert a selective XML index to a secondary selective XML index using the DROP_EXISTING option. ‘%.*ls’ is a selective XML index.

SQL Server Error Msg 3119 – Problems were identified while planning for the RESTORE statement. Previous messages provide details.

SQL Server Error Msg 33124 – Database encryption scan for database ‘%.*ls’ cannot complete since one or more files are offline. Bring the files online to run the scan to completion.

SQL Server Error Msg 8722 – Cannot execute query. Semantic affecting hint ‘%.*ls’ appears in the ‘%.*ls’ clause of object ‘%.*ls’ but not in the corresponding ‘%.*ls’ clause.  Change the OPTION (TABLE HINTS…) clause so the semantic affecting hints match the WITH clause.

SQL Server Error Msg 47038 – Reason: Login failed because client disconnected when fedauth specific processing was going on during login.

SQL Server Error Msg 20811 – Replication monitoring refresher for %s.

SQL Server Error Msg 11505 – The discovered type with the XML schema collection id %d in database %d is invalid.

SQL Server Error Msg 16302 – Role ‘%.*ls’ not found.

SQL Server Error Msg 20551 – Profile used by the Windows Synchronization Manager.

SQL Server Error Msg 19402 – A duplicate availability replica ‘%.*ls’ was specified in the READ_ONLY_ROUTING_LIST for availability replica ‘%.*ls’. Inspect the replica list that you specified in your command, and remove the duplicate replica name or names from the list. Then retry the command.

SQL Server Error Msg 8514 – Microsoft Distributed Transaction Coordinator (MS DTC) PREPARE acknowledgement failed: %hs.

SQL Server Error Msg 14686 – The MDWInstance and MDWDatabase parameters of the configuration store cannot be null.

SQL Server Error Msg 7984 – System table pre-checks: Object ID %d. Page %S_PGID has unexpected page type %d. Check statement terminated due to unrepairable error.

SQL Server Error Msg 35504 – server encryption protector

SQL Server Error Msg 15391 – sp_indexoption is not supported for XML Index and the table has an XML index on it. Use ALTER INDEX instead to set the option for ALL the indexes.

SQL Server Error Msg 22105 – Change tracking is not enabled on table ‘%.*ls’.

SQL Server Error Msg 33134 – Principal ‘%ls’ could not be resolved. Error message: ‘%ls’