Tag: SQL Server Errors

SQL Server Error Msg Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. – 16

SQL Server Error Msg 14148 – Invalid ‘%s’ value. Valid values are ‘true’ or ‘false’.

SQL Server Error Msg 49704 – Failed to apply server override on category ‘%.*ls’, because physical db or instance ‘%.*ls’ in server ‘%.*ls’ is currently not in ‘Ready’ or ‘Deactivated’ state.

SQL Server Error Msg 5319 – Aggregates are not allowed in a WHEN clause of a MERGE statement.

SQL Server Error Msg 49959 – ERROR: The environment variable MSSQL_COLLATION contains an invalid collation ‘%.*ls’.

SQL Server Error Msg 40561 – Database copy failed. Either the source or target database does not exist.

SQL Server Error Msg 13387 – Provider Error – No explanation is available, consult EKM Provider for details

SQL Server Error Msg 11002 – Deferred accessor validation occurred. Invalid binding for this column.

SQL Server Error Msg 8946 – Table error: Allocation page %S_PGID has invalid %ls page header values. Type is %d. Check type, alloc unit ID and page ID on the page.

SQL Server Error Msg 8189 – You do not have permission to run ‘%ls’.

SQL Server Error Msg 991 – Failed to take the host database ‘%.*ls’ offline when one or more of its partition databases is marked as suspect.

SQL Server Error Msg Invalid length parameter passed to the LEFT or SUBSTRING function. – 16

SQL Server Error Msg 1086 – The FOR XML and FOR JSON clauses are invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing a set operator using derived table or common table expression or view and apply FOR XML or FOR JSON on top of it.

SQL Server Error Msg 2814 – A possible infinite recompile was detected for SQLHANDLE %hs, PlanHandle %hs, starting offset %d, ending offset %d.  The last recompile reason was %d.

SQL Server Error Msg 21255 – Column ‘%s’ already exists in table ‘%s’.

SQL Server Error Msg 7321 – An error occurred while preparing the query “%ls” for execution against OLE DB provider “%ls” for linked server “%ls”. %ls

SQL Server Error Msg 3216 – RESTORE REWINDONLY is only applicable to tape devices.

SQL Server Error Msg 49802 – Database is unavailable at the moment, please retry connection at later time.

SQL Server Error Msg 2528 – DBCC execution completed. If DBCC printed error messages, contact your system administrator.

SQL Server Error Msg 8415 – The activated task was aborted because the invoked stored procedure ‘%ls’ did not issue COMMIT or ROLLBACK on one or more transactions that it begun.