SQL Server Errors or Failures from Error: 4129 to Error: 4150
Error: 4129, Severity: 16, The inline function “%.*ls” cannot take correlated parameters or subqueries because it uses a full-text operator.
Error: 4130, Severity: 16, A duplicate hint was specified for the BULK rowset.
Error: 4131, Severity: 16, A compile-time literal value is specified more than once for the variable “%.*ls” in one or more OPTIMIZE FOR clauses.
Error: 4132, Severity: 16, The value specified for the variable “%.*ls” in the OPTIMIZE FOR clause could not be implicitly converted to that variable’s type.
Error: 4133, Severity: 16, Only a scalar expression may be specified as the argument to the RETURN statement.
Error: 4134, Severity: 16, Metadata stored on disk for computed column ‘%.*ls’ in table ‘%.*ls’ did not match the column definition. In order to avoid possible index corruption, please drop and recreate this computed column.
Error: 4135, Severity: 16, Synonym ‘%.*ls’ is defined over queue ‘%.*ls’. Synonyms on queues are not allowed.
Error: 4136, Severity: 16, The hint ‘%.*ls’ cannot be used with the hint ‘%.*ls’.
Error: 4137, Severity: 16, A format file cannot be specified together with SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB option.
Error: 4138, Severity: 16, Conflicting locking hints are specified for table “%.*ls”. This may be caused by a conflicting hint specified for a view.
Error: 4139, Severity: 16, Cannot process the query because it references the common language runtime (CLR) table-valued function “%.*ls” with a hint through view “%.*ls”.
Error: 4140, Severity: 15, The READCOMMITTEDLOCK lock hint is not allowed on the target table of an INSERT statement.
Error: 4141, Severity: 16, Nested CLR type updates are not allowed.
Error: 4142, Severity: 16, Aggregates are not allowed in the RECEIVE list.
Error: 4143, Severity: 16, The bulk openrowset provider is not a valid target for %.*ls.
Error: 4144, Severity: 16, The hint ‘%.*ls’ is not allowed when inserting into remote tables.
Error: 4145, Severity: 15, An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’.
Error: 4146, Severity: 16, Statistics can only be created on columns.
Error: 4148, Severity: 16, XML methods are not allowed in a GROUP BY clause.
Error: 4150, Severity: 16, Hints are not allowed on recursive common table expression (CTE) references. Consider removing hint from recursive CTE reference ‘%.*ls’.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.