Tag: SQL Server Errors

SQL Server Error Msg 19436 – Always On: A failure [%d] was encountered while waiting for LSN %S_LSN to be hardened on the Commit Manager [%d] for database ID [%d] on partner ID [%s].

SQL Server Error Msg 11404 – ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ is referenced by %d indexed view(s), but source table ‘%.*ls’ is only referenced by %d matching indexed view(s). Every indexed view on the target table must have at least one matching indexed view on the source table.

SQL Server Error Msg 9831 – %ls cannot be larger than length of string.\nParameter name: %ls.

SQL Server Error Msg 14516 – Proxy (%d) is not allowed for subsystem “%s” and user “%s”. Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy.

SQL Server Error Msg 17404 – The server resumed execution after being idle for %d seconds.

SQL Server Error Msg 40901 – The elastic pool storage limit in megabytes cannot exceed (%d) in service tier ‘%.*ls’.

SQL Server Error Msg 5541 – An open mode must be used when a FILESTREAM column is opened as a file.

SQL Server Error Msg 8176 – Resync procedure expects value of key ‘%.*ls’, which was not supplied.

SQL Server Error Msg 14372 – The schedule was not deleted because it is being used by one or more jobs.

SQL Server Error Msg 22527 – Invalid value specified for %s. Valid values are ‘day’, ‘days’, ‘dd’, ‘year’, ‘years’, ‘yy’, ‘yyyy’, ‘month’, ‘months’, ‘mm’, ‘week’, ‘weeks’, ‘wk’, ‘hour’, ‘hours’, ‘hh’, ‘minute’, ‘minutes’, ‘mi’.

SQL Server Error Msg 8183 – Only UNIQUE or PRIMARY KEY constraints can be created on computed columns, while CHECK, FOREIGN KEY, and NOT NULL constraints require that computed columns be persisted.

SQL Server Error Msg 7901 – The repair statement was not processed. This level of repair is not supported when the database is in emergency mode.

SQL Server Error Msg 10793 – Both an index and a PRIMARY KEY constraint have been defined inline, with the definition of column ‘%.*ls’, table ‘%.*ls’. Defining both an index and a PRIMARY KEY constraint inline with the column definition is not allowed.

SQL Server Error Msg 6384 – It is not allowed to specify a path which contains ‘*’ only for the URI or only for the name of the node for selective XML index ‘%.*ls’.

SQL Server Error Msg 27201 – Values are missing for required parameters in this package. Specify values in order to start the validation.

SQL Server Error Msg 6980 – Invalid restriction for type ‘%s’. The particle in the restricted type may not have an occurrence range more permissive than that of the corresponding particle in the base type.

SQL Server Error Msg 46913 – The USE PLAN hint is not supported for queries that reference external tables. Consider removing USE PLAN hint.

SQL Server Error Msg 40635 – Client with IP address “%.*ls” is temporarily blocked.

SQL Server Error Msg 4988 – Cannot persist computed column ‘%.*ls’. Underlying object ‘%.*ls’ has a different owner than table ‘%.*ls’.

SQL Server Error Msg 40050 – Corrupted LOB row.