Tag: SQL Server Errors

SQL Server Error Msg Cannot define foreign key constraint ‘%.*ls’ with cascaded DELETE or UPDATE on table ‘%.*ls’ because table is system-versioned. – 16

SQL Server Error Msg 7601 – Cannot use a CONTAINS or FREETEXT predicate on %S_MSG ‘%.*ls’ because it is not full-text indexed.

SQL Server Error Msg 26071 – Failed to load the Cluster Resource Libraries: clusapi.dll and resutils.dll. SQL Server will be unable to accept TCP connections on clustered listeners.

SQL Server Error Msg 41071 – Cannot read the persisted configuration of Always On availability group with corresponding resource ID ‘%.*ls’.  The persisted configuration is written by a higher-version SQL Server that hosts the primary availability replica.  Upgrade the local SQL Server instance to allow the local availability replica to become a secondary replica.

SQL Server Error Msg 21379 – Cannot drop article ‘%s’ from publication ‘%s’ because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.

SQL Server Error Msg 2790 – Cannot use a column of type TEXT, NTEXT, or IMAGE in a constraint expression.

SQL Server Error Msg 19140 – Unable to initialize the communication listeners.

SQL Server Error Msg 14074 – The server ‘%s’ is already listed as a Publisher.

SQL Server Error Msg 33244 – SQL Server Audit failed to create an audit file related to the audit ‘%s’ in the directory ‘%s’. Make sure that the disk is not full and that the SQL Server service account has the required permissions to create and write to the file.

SQL Server Error Msg 8606 – This index operation requires %I64d KB of memory per DOP. The total requirement of %I64d KB for DOP of %lu is greater than the sp_configure value of %lu KB set for the advanced server configuration option “index create memory (KB)”.  Increase this setting or reduce DOP and rerun the query.

SQL Server Error Msg 10344 – Internal table access error: failed to access the Trusted Assemblies internal table with HRESULT: 0x%x. Contact Customer Support Services.

SQL Server Error Msg 14841 – The filter predicate ‘%.*ls’ for table ‘%.*ls’ cannot be replaced with ‘%.*ls’ because conditions necessary to perform the replacement are not satisfied.

SQL Server Error Msg 4425 – Cannot specify outer join operators in a query containing joined tables. View or function ‘%.*ls’ contains outer join operators.

SQL Server Error Msg 8987 – No help available for DBCC statement ‘%.*ls’.

SQL Server Error Msg 40167 – A paired CloudDB fabric node failed and database %d must be shutdown.

SQL Server Error Msg 8686 – Cursor plan forcing failed because input plan has more than one node with OperationType=%ls. Consider using an XML cursor plan captured from SQL Server without modification.

SQL Server Error Msg 19205 – The operating system does not support Channel Bindings, but the server is configured to require Extended Protection. Update the operating system or disable Extended Protection.

SQL Server Error Msg 21425 – The @publisher parameter may not be NULL for heterogeneous publishers.

SQL Server Error Msg 3212 – The mirror device “%ls” and the mirror device “%ls” have different device specifications.

SQL Server Error Msg 27135 – The database, ‘%ls’, already exists. Rename or remove the existing database, and then run SQL Server Setup again.