Tag: SQL Server Errors

SQL Server Error Msg 21788 – Invalid parameter passed to sp_IHSetXactBatching.  The bit flag to enable/disable Xact batching must be 0 or 1.

SQL Server Error Msg 15011 – Database option ‘%s’ does not exist. Specify a valid database option.

SQL Server Error Msg 6210 – CLR type ‘%.*ls’ is not fully comparable.

SQL Server Error Msg 5239 – Unable to process object ID %ld (object ‘%.*ls’) because this DBCC command does not support objects of this type.

SQL Server Error Msg 19492 – The availability database %ls in availailability group %ls is in an invalid state to perform an internal operation. Refer to the error code for more details. If this condition persists, contact the system administrator.

SQL Server Error Msg 8489 – The dialog has exceeded the specified LIFETIME.

SQL Server Error Msg 14299 – Server ‘%s’ is an MSX. Cannot enlist one MSX into another MSX.

SQL Server Error Msg 19474 – Failed to set the resource dependency expression ‘%ls’ for the WSFC resource ‘%.*ls’. The error code is %d. The WSFC service may not be running or may be inaccessible in its current state, or the specified arguments are invalid. For information about this error code, see “System Error Codes” in the Windows Development documentation.

SQL Server Error Msg 10 – 12440

SQL Server Error Msg 7686 – Cannot use a CONTAINS, FREETEXT, CONTAINSTABLE or FREETEXTTABLE construct on table or indexed view ‘%.*ls’ because none of its columns are full-text indexed. Register at least one column for full-text search using ALTER FULLTEXT INDEX statement.

SQL Server Error Msg 5123 – CREATE FILE encountered operating system error %ls while attempting to open or create the physical file ‘%.*ls’.

SQL Server Error Msg 21619 – Must provide both @SelectColumnList and @InsColumnList.

SQL Server Error Msg 4309 – The state of file “%ls” prevents restoring individual pages.  Only a file restore is currently possible.

SQL Server Error Msg 33429 – The non-transacted FILESTREAM handle %d does not exist.

SQL Server Error Msg 20066 – Profile not defined.

SQL Server Error Msg 17164 – SQL Server detected %d sockets with %d cores per socket and %d logical processors per socket, %d total logical processors; using %d logical processors based on SQL Server licensing. This is an informational message; no user action is required.

SQL Server Error Msg 20553 – Could not clean up the distribution history tables.

SQL Server Error Msg 6941 – Invalid type definition for type ‘%s’, types with complex content can only be derived from base types which have complex content

SQL Server Error Msg 4525 – Cannot use hint ‘%ls’ on view ‘%.*ls’ that has snapshot materialization before the view is refreshed.

SQL Server Error Msg 5544 – FILESTREAM: effective level = %d (remote access enabled), configured level = %d, file system access share name = ‘%.*ls’.