Tag: SQL Server Errors

SQL Server Error Msg 3260 – An internal buffer has become full.

SQL Server Error Msg 30077 – The full-text query did not use the value specified for the OPTIMIZE FOR query hint. Only single terms are allowed as values for full-text queries that contain an OPTIMIZE FOR query hint. Modify the OPTIMIZE FOR query hint value to be a single, non-empty term.

SQL Server Error Msg 1831 – File ONLINE/OFFLINE syntax cannot be used with CREATE DATABASE.

SQL Server Error Msg 13042 – integer

SQL Server Error Msg 1435 – %ls received unexpected database mirroring error response: status %u, severity %u, state %u, string %.*ls.

SQL Server Error Msg 304 – ‘%I64d’ is out of range for index/statistics option ‘%.*ls’. See sp_configure option ‘%ls’ for valid values.

SQL Server Error Msg 40187 – The metadata record for the partition does not exist.

SQL Server Error Msg 40076 – Too few columns from remote rowset %ls.%ls.%ls.

SQL Server Error Msg 3002 – Cannot BACKUP or RESTORE a database snapshot.

SQL Server Error Msg 7638 – Warning: Request to stop change tracking has deleted all changes tracked on table or indexed view ‘%ls’.

SQL Server Error Msg 7670 – Column ‘%.*ls’ cannot be used for full-text search because it is not a character-based, XML, image or varbinary(max) type column or it is encrypted.

SQL Server Error Msg 23513 – Item does not exist.

SQL Server Error Msg 41171 – Failed to create availability group ‘%.*ls’, because a Windows Server Failover Cluster (WSFC) group with the specified name already exists.  The operation has been rolled back successfully.  To retry creating an availability group, either remove or rename the existing WSFC group, or retry the operation specifying a different availability group name.

SQL Server Error Msg 19056 – The comparison operator in the filter is not valid.

SQL Server Error Msg 14400 – Proxy %d does not have access to subsystem %d. Please use sp_grant_proxy_to_subsystem to grant permissions to this proxy.

SQL Server Error Msg 22227 – TIERED Storage Scanner encountered an error message “%ls” in “%ls”.

SQL Server Error Msg 2023 – Metadata was not updated for the schema-bound object ‘%ls’.

SQL Server Error Msg 14896 – Reconciliation proc %.*ls brought down the local batch ID for the stretch table ‘%.*ls’ of database ‘%.*ls’ from %I64d to %I64d.

SQL Server Error Msg 33222 – Audit ‘%.*ls’ failed to %S_MSG . For more information, see the SQL Server error log. You can also query sys.dm_os_ring_buffers where ring_buffer_type = ‘RING_BUFFER_XE_LOG’.

SQL Server Error Msg 18058 – Failed to load format string for error %d, language id %d. Operating system error: %s. Check that the resource file matches SQL Server executable, and resource file in localized directory matches the file under English directory. Also check memory usage.