Error |
Severity |
Description |
251 |
16 |
Could not allocate ancillary table for query optimization. Maximum
number of tables in a query (%d) exceeded. |
252 |
16 |
Recursive common table expression '<Common Table Expression Name>' does not contain a top-level UNION ALL operator. |
253 |
16 |
Recursive member of a common table expression '<Common Table Expression Name>' has multiple recursive references. |
254 |
16 |
Prefixed columns are not allowed in the column list of a PIVOT operator. |
255 |
16 |
Pseudocolumns are not allowed in the column list of a PIVOT operator. |
256 |
16 |
The data type int is invalid for the substring
function. Allowed types are: char/varchar, nchar/nvarchar, and
binary/varbinary. |
257 |
16 |
Implicit conversion from data type %ls to %ls is not allowed. Use
the CONVERT function to run this query. |
258 |
16 |
Cannot call methods on %ls. |
259 |
16 |
Ad hoc updates to system catalogs are not enabled. The system
administrator must reconfigure SQL Server to allow this. |
260 |
16 |
Disallowed implicit conversion from data type %ls to data type
%ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query. |
261 |
16 |
'%.*ls' is not a recognized function. |
262 |
16 |
%ls permission denied in database '%.*ls'. |
263 |
16 |
Must specify table to select from. |
264 |
16 |
Column name '%.*ls' appears more than once in the result column
list. |
265 |
16 |
The column name "%.*ls" specified in the %ls operator conflicts with the existing column name in the %ls argument. |
266 |
16 |
Transaction count after EXECUTE indicates that a COMMIT or
ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count
= %ld. |
267 |
16 |
Object '%.*ls' cannot be found. |
268 |
16 |
Cannot run SELECT INTO in this database. The database owner must
run sp_dboption to enable this option. |
270 |
16 |
Object '%.*ls' cannot be modified. |
271 |
16 |
SQL Server 2005, SQL Server 2008, SQL Server 2012 - The column '<Column Name>' cannot be modified because it is either a computed column or is the result of a UNION operator.
SQL Server 2000 - Column '<Column Name>' cannot be modified because it is a computed column.
|
272 |
16 |
Cannot update a timestamp column. |
273 |
16 |
Cannot insert a non-null value into a timestamp column. Use INSERT
with a column list or with a default of NULL for the timestamp column. |
275 |
16 |
Prefixes are not allowed in value or pivot columns of an UNPIVOT operator. |
276 |
16 |
Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator. |
277 |
16 |
The column "%.*ls" is specified multiple times in the column list of the UNPIVOT operator. |
278 |
16 |
The text, ntext, and image data types cannot be used in a GROUP BY
clause. |
279 |
16 |
The text, ntext, and image data types are invalid in this subquery
or aggregate expression. |
280 |
16 |
Only text, ntext, and image columns are valid with the TEXTPTR
function. |
281 |
16 |
<Style number> is not a valid style number when converting from %ls to a
character string. |
282 |
10 |
The '%.*ls' procedure attempted to return a status of NULL, which
is not allowed. A status of 0 will be returned instead. |
283 |
16 |
READTEXT cannot be used on inserted or deleted tables within an
INSTEAD OF trigger. |
284 |
16 |
Rules cannot be bound to text, ntext, or image data types. |
285 |
16 |
The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used
with views or functions. |
286 |
16 |
The logical tables INSERTED and DELETED cannot be updated. |
287 |
16 |
The %ls statement is not allowed within a trigger. |
288 |
16 |
The PATINDEX function operates on char, nchar, varchar, nvarchar,
text, and ntext data types only. |
290 |
16 |
Invalid EXECUTE statement using object "%ls", method "%ls". |
291 |
16 |
CAST or CONVERT: invalid attributes specified for type '%.*ls' |
292 |
16 |
There is insufficient result space to convert a smallmoney value
to varchar/nvarchar. |
293 |
16 |
Cannot convert char value to smallmoney. The char value has
incorrect syntax. |
294 |
16 |
The conversion from char data type to smallmoney data type
resulted in a smallmoney overflow error. |
295 |
16 |
Syntax error converting character string to smalldatetime data
type. |
296 |
16 |
The conversion of char data type to smalldatetime data type
resulted in an out-of-range smalldatetime value. |
297 |
16 |
The user does not have permission to perform this action. |
298 |
16 |
The conversion from datetime data type to smalldatetime data type
resulted in a smalldatetime overflow error. |
299 |
16 |
The DATEADD function was called with bad type %ls. |
300 |
14 |
%ls permission was denied on object '%.*ls', database '%.*ls'. |
301 |
16 |
Query contains an outer-join request that is not permitted. |
302 |
16 |
The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression. |
303 |
16 |
The table '%.*ls' is an inner member of an outer-join clause. This
is not allowed if the table also participates in a regular join clause. |
304 |
16 |
'%d' is out of range for index option '%.*ls'. See sp_configure option '%ls' for valid values. |
305 |
16 |
The XML data type cannot be compared or sorted, except when using the IS NULL operator. |
306 |
16 |
The text, ntext, and image data types cannot be compared or
sorted, except when using IS NULL or LIKE operator. |
307 |
16 |
Index ID %d on table '%.*ls' (specified in the FROM clause) does
not exist. |
308 |
16 |
Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does
not exist. |
309 |
16 |
Cannot use index "%.*ls" on table "%.*ls" in a hint. XML indexes are not allowed in hints. |
310 |
16 |
The value <MAXRECURSION value> specified for the MAXRECURSION option exceeds the allowed maximum of %d. |
311 |
16 |
Cannot use text, ntext, or image columns in the 'inserted' and
'deleted' tables. |
312 |
16 |
Cannot reference text, ntext, or image columns in a filter stored
procedure. |
313 |
16 |
An insufficient number of arguments were
supplied for the procedure or function %.*ls. |
314 |
16 |
Cannot use GROUP BY ALL with the special tables INSERTED or DELETED. |
315 |
16 |
Index "%.*ls" on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online. |
316 |
16 |
The index ID %d on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online. |
317 |
16 |
Table-valued function '<Function Name>' cannot have a column alias. |
318 |
16 |
The table (and its columns) returned by a table-valued method need to be aliased. |
319 |
16 |
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. |
320 |
16 |
The compile-time variable value for '%.*ls' in the OPTIMIZE FOR clause must be a literal. |
321 |
15 |
%.*ls is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90. |
322 |
16 |
The variable "%.*ls" is specified in the OPTIMIZE FOR clause, but is not used in the query. |
323 |
16 |
The 'COMPUTE' clause is not allowed in a statement containing an INTERSECT or EXCEPT operator. |
324 |
15 |
The 'ALL' version of the %.*ls operator is not supported. |
325 |
15 |
Incorrect syntax near '%.*ls'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. |
326 |
16 |
Multi-part identifier '%.*ls' is ambiguous. Both columns '%.*ls' and '%.*ls' exist. |
327 |
16 |
Function call '%.*ls' is ambiguous: both a user-defined function and a method call with this name exist. |
328 |
16 |
A cursor plan could not be generated for the given statement because the textptr() function was used on a LOB column from one of the base tables. |
329 |
16 |
Each GROUP BY expression must contain at least one column reference. |
330 |
15 |
The target '<Object Name>' of the OUTPUT INTO clause cannot be a view or common table expression. |
331 |
15 |
The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled triggers. |
332 |
15 |
The target table '<Table Name>' of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint '<Primary Key or Foreign Key Constraint Name>'. |
333 |
15 |
The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule '<CHECK Constraint Name>'. |
334 |
15 |
The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause. |
335 |
16 |
Function call cannot be used to match a target table in the FROM clause of a DELETE or UPDATE statement. Use function name '%.*ls' without parameters instead. |
336 |
15 |
Incorrect syntax near '%.*ls'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon. |
337 |
10 |
Warning: the floating point value '%.*ls' is too small. It will be interpreted as 0. |
338 |
16 |
READEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views, remote tables, and inserted or deleted tables inside triggers. |
339 |
16 |
DEFAULT or NULL are not allowed as explicit identity values. |
340 |
16 |
Cannot create the trigger "%.*ls" on view "%.*ls". AFTER triggers cannot be created on views. |
341 |
16 |
Replication filter procedures may not contain columns of large object, large value, XML or CLR type. |
342 |
16 |
Column "%.*ls" is not allowed in this context, and the user-defined function or aggregate "%.*ls" could not be found. |
343 |
16 |
Unknown object type '%.*ls' used in a CREATE, DROP, or ALTER statement. |
344 |
16 |
Remote function reference '%.*ls' is not allowed, and the column name '%.*ls' could not be found or is ambiguous. |
345 |
16 |
Function '%.*ls' is not allowed in the OUTPUT clause, because it performs user or system data access, or is assumed to perform this access. A function is assumed by default to perform data access if it is not schemabound. |
346 |
15 |
The parameter "<Parameter Name>" can not be declared READONLY since it is not a table-valued parameter. |
347 |
16 |
The table-valued parameter "%.*ls" cannot be declared as an OUTPUT parameter. |
348 |
16 |
The table variable "%.*ls" can not be passed to a stored procedure with the OUTPUT option. |
349 |
16 |
The procedure "%.*ls" has no parameter named "%.*ls". |
350 |
16 |
The column "%.*ls" does not have a valid data type. A column cannot be of a user-defined table type. |
351 |
16 |
Column, parameter, or variable %.*ls. : Cannot find data type %.*ls. |
352 |
15 |
The table-valued parameter "%.*ls" must be declared with the READONLY option. |
353 |
16 |
Function '%.*ls' is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. This is because the function performs user or system data access, or is assumed to perform this access. By default, a function is assumed to perform data access if it is not schema-bound. |
354 |
15 |
The target '%.*ls' of the INSERT statement cannot be a view or common table expression when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. |
355 |
15 |
The target table '<Table Name>' of the INSERT statement cannot have any enabled triggers when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. |
356 |
15 |
The target table '%.*ls' of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found reference constraint '%ls'. |
357 |
15 |
The target table '%.*ls' of the INSERT statement cannot have any enabled rules when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found rule '%ls'. |
358 |
15 |
The target table '%.*ls' of the MERGE statement cannot have any enabled rules. Found rule '%ls'. |
359 |
15 |
The target '%.*ls' of an OUTPUT INTO clause has an index with the ignore_dup_key option and cannot be used when an OUTPUT clause is also used. |
360 |
15 |
The target column list of an INSERT, UPDATE, or MERGE statement cannot contain both a sparse column and the column set that contains the sparse column. Rewrite the statement to include either the sparse column or the column set, but not both. |
361 |
16 |
The number of target columns that are specified in an INSERT, UPDATE, or MERGE statement exceeds the maximum of %d. This total number includes identity, timestamp, and columns that have default values. To correct this error, change the query to target a sparse column set instead of single sparse columns. |
362 |
16 |
The query processor could not produce a query plan because the name '%.*ls' in the FORCESEEK hint on table or view '<Object Name>' did not match the key column names of the index '<Index Name>'. |
363 |
16 |
The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the %S_MSG specified by index '%.*ls'. |
364 |
16 |
The query processor could not produce a query plan because the FORCESEEK hint on view '<View Name>' is used without a NOEXPAND hint. Resubmit the query with the NOEXPAND hint or remove the FORCESEEK hint on the view. |
365 |
16 |
The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' specified more seek columns than the number of key columns in index '%.*ls'. |
366 |
16 |
The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the column store index '%.*ls'. |
401 |
16 |
Unimplemented statement or expression %ls. |
402 |
16 |
The data types %s and %s are incompatible in the %s operator. |
403 |
16 |
Invalid operator for data type. Operator equals
add, type equals text. |
404 |
16 |
The column reference "inserted.%.*ls" is not allowed because it refers to a base table that is not being modified in this statement. |
405 |
16 |
A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement. |
406 |
16 |
%ls cannot be used in the PIVOT operator because it is not invariant to NULLs. |
407 |
16 |
Internal error. The string routine in file %hs, line %d failed with HRESULT 0x%x. |
408 |
16 |
A constant expression was encountered in the ORDER BY list, position %i. |
409 |
16 |
The %ls operation cannot take a %ls data type as an argument. |
410 |
20 |
COMPUTE clause #%d 'BY' expression #%d is not in the order by
list. |
411 |
16 |
COMPUTE clause #%d, aggregate expression #%d is not in the select
list. |
412 |
16 |
The column "%.*ls" is not updatable because it is derived or constant. |
413 |
16 |
Correlated parameters or sub-queries are not supported by the inline function "%.*ls". |
414 |
16 |
UPDATE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF UPDATE trigger. |
415 |
16 |
DELETE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF DELETE trigger. |
416 |
16 |
The service queue "%.*ls" cannot be directly updated. |
417 |
16 |
TOP is not allowed in an UPDATE or DELETE statement against a partitioned view. |
418 |
16 |
Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object '%.*ls'. |
420 |
16 |
The text, ntext, and image data types cannot be used in an ORDER
BY clause. |
421 |
16 |
The text/ntext/image data type cannot be selected as DISTINCT because it is not comparable. |
422 |
16 |
Common table expression defined but not used. |
423 |
16 |
Xml data type methods are not supported in check constraints. Create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls". |
424 |
16 |
Xml data type methods are not supported in computed column definitions of table variables and return tables of table-valued functions. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement. |
425 |
16 |
Data type %ls of receiving variable is not equal to the data type
%ls of column '%.*ls'. |
426 |
16 |
The length %d of the receiving variable is less than the length %d
of the column '%.*ls'. |
427 |
20 |
Could not load sysprocedures entries for constraint ID %d in
database ID %d. |
428 |
20 |
Could not find row in sysconstraints for constraint ID %d in
database ID %d. |
429 |
20 |
Could not find new constraint ID %d in sysconstraints, database ID
%d, at compile time. |
430 |
20 |
Could not resolve table name for object ID %d, database ID %d,
when compiling foreign key. |
431 |
19 |
Could not bind foreign key constraint. Too many tables involved in
the query. |
432 |
16 |
Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls". |
433 |
20 |
Could not find CHECK constraint for '%.*ls', although the table is
flagged as having one. |
434 |
16 |
Function '%ls' is not allowed in the OUTPUT clause. |
435 |
16 |
Xml data type methods are not supported in computed column definitions. Create a scalar user-defined function to wrap the method invocation. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement. |
436 |
20 |
Could not open referenced table ID %d in database ID %d. |
437 |
20 |
Could not resolve the referenced column name in table ID %d. |
438 |
20 |
Could not resolve the referencing column name in table ID %d. |
439 |
20 |
Could not find FOREIGN KEY constraints for table '%.*ls' in
database ID %d although the table is flagged as having them. |
440 |
16 |
Internal query compilation error. The stack overflow could not be handled. |
441 |
16 |
Cannot use the '%ls' function on a remote data source. |
442 |
16 |
The NEST argument must be a column reference. Expressions are not allowed. |
443 |
16 |
Invalid use of 'getdate' within a
function.
Invalid use of 'INSERT' within a function.
Invalid use of 'UPDATE' within a function. |
444 |
16 |
Select statements included within a function cannot return data to
a client. |
445 |
16 |
COLLATE clause cannot be used on expressions containing a COLLATE
clause. |
446 |
16 |
Cannot resolve collation conflict for %ls operation. |
447 |
16 |
Expression type %ls is invalid for COLLATE clause.
|
448 |
16 |
Invalid collation '%.*ls'. |
449 |
16 |
Collation conflict caused by collate clauses with different
collation '%.*ls' and '%.*ls'. |
450 |
16 |
Code page translations are not supported for the text data type.
From: %d To: %d. |
451 |
16 |
Cannot resolve collation conflict for column %d in %ls statement. |
452 |
16 |
COLLATE clause cannot be used on user-defined data types. |
453 |
16 |
Collation '%.*ls' is supported on Unicode data types only and
cannot be set at the database or server level. |
454 |
16 |
The UNNEST argument must be a nested table column. |
455 |
16 |
The last statement included within a function
must be a return statement. |
456 |
16 |
Implicit conversion of %ls value to %ls cannot be performed
because the resulting collation is unresolved due to collation conflict. |
457 |
16 |
Implicit conversion of %ls value to %ls cannot be performed
because the collation of the value is unresolved due to a collation conflict. |
458 |
16 |
Cannot create the SELECT INTO target table "%.*ls" because the xml column "%.*ls" is typed with a schema collection "%.*ls" from database "%.*ls". Xml columns cannot refer to schemata across databases. |
459 |
16 |
Collation '%.*ls' is supported on Unicode data types only and cannot be applied to char, varchar or text data types. |
460 |
16 |
DISTINCT operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'. |
461 |
16 |
TOP operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'. |
462 |
16 |
Outer join is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'. |
463 |
16 |
Functions with parameters are not allowed in the recursive part of a recursive common table expression '%.*ls'. |
464 |
16 |
Functions with side effects are not allowed in the recursive part of a recursive common table expression '%.*ls'. |
465 |
16 |
Recursive references are not allowed in subqueries. |
466 |
16 |
UNION operator is not allowed in the recursive part of a recursive common table expression '%.*ls'. |
467 |
16 |
GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression '<CTE Name>'. |
468 |
16 |
Cannot resolve the collation conflict between "%.*ls" and "%.*ls" in the %ls operation. |
469 |
16 |
An explicit column list must be specified for target table '%.*ls' when table hint KEEPIDENTITY is used and the table contains an identity column. |
470 |
16 |
The synonym "<Synonym Name>" referenced synonym "<Synonym Name>". Synonym chaining is not allowed. |
471 |
16 |
Only one of the three options, SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB, can be specified. |
472 |
16 |
Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified. |
473 |
16 |
The incorrect value "%.*ls" is supplied in the PIVOT operator. |
474 |
16 |
Unable to load the computed column definitions for table "%.*ls". |
475 |
16 |
Invalid SAMPLE clause. Only table names in the FROM clause of SELECT, UPDATE, and DELETE queries may be sampled. |
476 |
16 |
Invalid PERCENT tablesample size "<sample_number>" for table "<Table Name>". The PERCENT tablesample size must be between 0 and 100. |
477 |
16 |
Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table "<Table Name>". The value or seed must be an integer. |
478 |
16 |
The TABLESAMPLE clause cannot be used in a view definition or inline table function definition. |
479 |
16 |
Invalid ROWS value or REPEATABLE seed "%I64d" in the TABLESAMPLE clause for table "%.*ls". The value or seed must be greater than 0. |
480 |
16 |
The TABLESAMPLE clause cannot be used with the table function "%.*ls". |
481 |
16 |
The TABLESAMPLE clause cannot be used with the linked server table "%.*ls". |
482 |
16 |
Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause. |
483 |
16 |
The OUTPUT clause cannot be used in an INSERT...EXEC statement. |
484 |
16 |
Cannot declare more than %d local variables. |
485 |
16 |
Views and inline functions cannot return xml columns that are typed with a schema collection registered in a database other than current. Column "%.*ls" is typed with the schema collection "%.*ls", which is registered in database "%.*ls". |
486 |
16 |
%.*ls does not allow specifying a schema name as a prefix to the assembly name. |
487 |
16 |
An invalid option was specified for the statement "%.*ls". |
488 |
16 |
%s columns must be comparable. The type of column "%.*ls" is "%s", which is not comparable. |
489 |
16 |
The OUTPUT clause cannot be specified because the target view "%.*ls" is a partitioned view. |
490 |
16 |
The resync functionality is temporarily disabled. |
491 |
16 |
A correlation name must be specified for the bulk rowset in the from clause. |
492 |
16 |
Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "%.*ls" is a duplicate. |
493 |
16 |
The column '%.*ls' that was returned from the nodes() method cannot be used directly. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks. |
494 |
16 |
The TABLESAMPLE clause can only be used with local tables. |
495 |
16 |
The return table column "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata. |
496 |
16 |
The parameter "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata. |
497 |
16 |
Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses. |
498 |
16 |
Invalid value in the TABLESAMPLE or the REPEATABLE clause. |
499 |
16 |
Invalid parameter for the getchecksum function. |
500 |
16 |
Trying to pass a table-valued parameter with %d column(s) where the corresponding user-defined table type requires %d column(s). |