Tag: SQL Server Errors

SQL Server Error Msg 23999 – Unspecified error(s) occurred.

SQL Server Error Msg 21610 – The failed attempt by sp_refresh_heterogeneous_publisher to refresh publisher ‘%s’ did not alter any meta data at the Oracle publisher. Make certain that the correct Oracle publisher has been identified and that the requirements for refreshing the Oracle publisher have been met.

SQL Server Error Msg 8669 – The attempt to maintain the indexed view “%.*ls” failed because it contains an expression on aggregate results, or because it contains a ranking or aggregate window function. Consider dropping the clustered index on the view, or changing the view definition.

SQL Server Error Msg 469 – An explicit column list must be specified for target table ‘%.*ls’ when table hint KEEPIDENTITY is used and the table contains an identity column.

SQL Server Error Msg 8981 – Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). The next pointer of %S_PGID refers to page %S_PGID. Neither %S_PGID nor its parent were encountered. Possible bad chain linkage.

SQL Server Error Msg 116 – Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

SQL Server Error Msg 33332 – DBCC CLEANUPCONVERSATIONS cannot be executed through MARS connection.

SQL Server Error Msg 7431 – Unable to delete OLE DB parameter properties.

SQL Server Error Msg 4983 – ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has an XML or spatial index ‘%.*ls’ on it. Only source table can have XML or spatial indexes in the ALTER TABLE SWITCH statement.

SQL Server Error Msg 47139 – Join contained availability group ‘%.*ls’ failed to create group master ‘%.*ls’ Database ID. Please retry the operation again.

SQL Server Error Msg 6632 – Invalid data type for the column “%ls”. CLR types cannot be used in an OpenXML WITH clause.

SQL Server Error Msg 35238 – Database ‘%.*ls’ cannot be added to availability group ‘%.*ls’.  The database does not exist on this SQL Server instance.  Verify that the database name is correct, then retry the operation.

SQL Server Error Msg 10771 – The CREDENTIAL option cannot be used with the FEDERATED_SERVICE_ACCOUNT = ON option.

SQL Server Error Msg 40858 – Elastic pool ‘%ls’ already exists in server: ‘%ls’

SQL Server Error Msg 29277 – Configuration manager enlistment is queuing a failure request for brick <%d> due to receiving new enlistment request from this brick.

SQL Server Error Msg 1131 – Failed to truncate AppendOnlyStorageUnit 0x%p. Will retry next time. This is an informational message only. No user action is required.

SQL Server Error Msg 10139 – Cannot create %S_MSG on view ‘%.*ls’ because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.

SQL Server Error Msg 18268 – Log was restored. Database: %s, creation date(time): %s(%s), first LSN: %s, last LSN: %s, number of dump devices: %d, device information: (%s). This is an informational message. No user action is required.

SQL Server Error Msg 950 – Database ‘%.*ls’ cannot be upgraded because its non-release version (%d) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.

SQL Server Error Msg 40054 – Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.