Export (0) Print
Expand All

Query Processor Errors

The following table lists the query processor errors that you might experience when you use SQL Server Compact 4.0.

Important note Important

If you experience any errors that have the prefix 'Internal error' when you use SQL Server Compact, try the operation again as the error might not reproduce. If the error appears again, you should immediately contact Microsoft Product Support Services. The internal errors cannot be resolved by common troubleshooting techniques.

Value

Error token

Description

Numeric parameters

String parameters

25500

SSCE_M_QP_BADOPT

Internal error: The execution plan cannot be generated.

Not applicable

Not applicable

25501

SSCE_M_QP_BADPARSE

There was an error parsing the query.

Token line number, Token line offset

Token in error

25502

SSCE_M_QP_SETLISTCOUNT

The count of column names and source expressions do not match.

Column name count, Source expression count

Not applicable

25503

SSCE_M_QP_BAD_COLNAME

The column name is not valid.

Not applicable

Node name (if any), Column name

25505

SSCE_M_QP_BADCNSTS

The constraint specified is not valid.

Not applicable

Not applicable

25506

SSCE_M_QP_NOMEMORY

There is not sufficient memory to complete the operation.

Not applicable

Not applicable

25507

SSCE_M_QP_UNCLOSEDCOMMENT

There is an unclosed comment block in the SQL statement. Ensure that there are balanced "/*" and "*/" comment markers in the SQL statement.

Not applicable

Not applicable

25508

SSCE_M_QP_TOKTOOLONG

The token specified is too long. The maximum length is 128 characters.

Maximum size of token (if known)

Token (if known)

25509

SSCE_M_QP_ATOF_OVERFLOW

A conversion from string to float data failed.

Not applicable

String

25510

SSCE_M_QP_NUME_OUTOFRANGE

A conversion from string to numeric data failed.

Not applicable

String value

25511

SSCE_M_QP_UNCLOSEDQUOTE

A quotation mark delimiter is missing from the end of the query.

Not applicable

Not applicable

25512

SSCE_M_QP_BADMONEY

Conversion from string to money data failed.

Not applicable

Bad value

25513

SSCE_M_QP_IDENTWITHNULL

Null values are not valid identifiers.

Not applicable

Identifier

25514

SSCE_M_QP_NAME_EMPTY

The identifier cannot be an empty string.

Not applicable

Not applicable

25515

SSCE_M_QP_NO_SCALAR_IN_SELECT

In aggregate and grouping expressions, the SELECT clause can contain only aggregates and grouping expressions.

Not applicable

Select clause

25516

SSCE_M_QP_NO_AGG_IN_AGG

Nested aggregate expressions are not allowed.

Not applicable

Not applicable

25517

SSCE_M_QP_NO_SCALAR_IN_HAVING

In aggregate and grouping expressions, the HAVING clause can contain only aggregate functions and grouping expressions.

Not applicable

Having clause

25518

SSCE_M_QP_NO_SCALAR_IN_AGGRORDERBY

In aggregate and grouping expressions, the ORDER BY clause can contain only aggregate functions and grouping expressions.

Not applicable

Not applicable

25519

SSCE_M_QP_NO_AGG_IN_GROUPBY

Expressions in the GROUP BY list cannot contain aggregate functions.

Not applicable

Not applicable

25520

SSCE_M_QP_NO_AGG_IN_ORDERBY

Expressions in the ORDER BY list cannot contain aggregate functions.

Not applicable

Not applicable

25521

SSCE_M_QP_NO_DUPEXPR_IN_ORDERBY

The ORDER BY list cannot have duplicate expressions.

Not applicable

Order by list, Duplicate expression

25522

SSCE_M_QP_DUP_TABLE_ALIAS

The table aliases must be unique.

Not applicable

Name of duplicate alias

25523

SSCE_M_QP_DUP_COLUMN_ALIAS

The column aliases must be unique.

Not applicable

Name of duplicate alias

25524

SSCE_M_QP_HAVING_WITHOUT_GROUPBY

A HAVING clause must have a GROUP BY clause (implicit or explicit).

Not applicable

Not applicable

25525

SSCE_M_QP_NO_AGG_IN_WHERE

The WHERE clause cannot refer to aggregate expressions.

Not applicable

Not applicable

25526

SSCE_M_QP_DUP_CNST

Duplicate constraints cannot be specified.

Not applicable

Not applicable

25527

SSCE_M_QP_AMBIGUOUS_FUNC

A function that uses the same signature already exists.

Not applicable

Name of function

25530

SSCE_M_QP_SETLIST_DUPCOLNAME

A column with the same name has already been specified.

Not applicable

Name of duplicate column

25531

SSCE_M_QP_AMBIGUOUS_COLNAME

The column name cannot be resolved to a table. Specify the table to which the column belongs.

Not applicable

Name of ambiguous column

25532

SSCE_M_QP_BAD_FLOAT_PRECISION

The float precision is not valid.

Not applicable

Not applicable

25533

SSCE_M_QP_LONGIDNAME

The identifier/column name is too long. The maximum length is 128 characters.

Not applicable

Name of column (if known)

25534

SSCE_M_QP_LOB_IN_ORDERBY

Large objects (ntext and image) cannot be used in ORDER BY clauses.

Not applicable

Not applicable

25536

SSCE_M_QP_INVALIDMETA_FOR_LOB

Length, precision or scale cannot be specified for NTEXT or IMAGE data types. Remove these attributes from the IMAGE or NTEXT data types in the DLL statement.

Not applicable

Not applicable

25537

SSCE_M_QP_SUBQUERY_COLUMN_MISMATCH

The columns in the subquery do not match.

Column ordinal

Column name

25538

SSCE_M_QP_ENCRYPTION_NO_DBPASSWORD

The database is encrypted. A password must be specified.

Not applicable

Not applicable

25539

SSCE_M_QP_BADLIKEESCCHAR

The escape character for the LIKE predicate is not valid.

Not applicable

Escape character

25540

SSCE_M_QP_BADDATEOPTION

The datepart is not valid.

Not applicable

Portion of data in error

25541

SSCE_M_QP_INVALID_IDENTIFIER

The identifier is not valid.

Not applicable

Identifier

25542

SSCE_M_QP_READONLYINSERT

Data cannot be added to a system table or a schema information view.

Not applicable

Name of read-only table

25543

SSCE_M_QP_READONLYUPDATE

Data cannot be updated in a system table or a schema information view.

Not applicable

Name of read-only table

25544

SSCE_M_QP_READONLYDELETE

Data cannot be deleted from a system table or a schema information view.

Not applicable

Name of read-only table

25545

SSCE_M_QP_NOINSERTCOLUMNS

A value must be provided for the INSERT statement into <table_name>.

Not applicable

Table name

25546

SSCE_M_QP_MODIFYPROTECTEDCOL

The column cannot be modified because it is an identity column or a system column.

Not applicable

Column name

25547

SSCE_M_QP_SCALARORDERBYNOTSUPPORTED

ORDER BY <column number> not supported.

Not applicable

Not applicable

25548

SSCE_M_QP_LOB_IN_DISTINCT

DISTINCT cannot be used with ntext and image data.

Not applicable

Not applicable

25549

SSCE_M_QP_LOB_IN_GROUPBY

GROUP BY cannot be used with ntext and image data.

Not applicable

Not applicable

25550

SSCE_M_QP_MULTI_IDENTITY_COLUMNS

Too many identity columns are specified for the table. Only one identity column for each table is allowed.

Not applicable

Not applicable

25551

SSCE_M_QP_BAD_IDENTITY_TYPE

The identity column must be either an integer or big integer data type and cannot be NULL.

Not applicable

Not applicable

25552

SSCE_M_QP_GROUPBY_MUST_REFERENCE_COLS

Elements in the GROUP BY clause must reference columns in the select list.

Not applicable

Not applicable

25553

SSCE_M_QP_CASCADEONSELFREFFK

A foreign key constraint that has an UPDATE or a DELETE CASCADE rule and self-references a column in the same table is not allowed.

Not applicable

Constraint name

25554

SSCE_M_QP_NODEFAULTONIDENTITYCOL

Defaults cannot be created on identity columns.

Not applicable

Name of table, Name of column

25555

SSCE_M_QP_SUBQUERY_NOLOBCOLUMNS

Subquery columns cannot be ntext or image data types.

Not applicable

Not applicable

25556

SSCE_M_QP_INVALID_CHARACTER_IN_IDENTIFIER

The number sign (#) is reserved and cannot be used as the first character of an identifier.

Not applicable

Invalid identifier

25557

SSCE_M_UNIONCOLUMNCOUNT

Expressions combined by a UNION operator must have the same number of columns.

Number of columns in first UNION expression, Number of columns in other UNION expression

Not applicable

25558

SSCE_M_DIFFERENTCOLUMNCOUNT

The number of columns in the query and the table must match.

Number of columns in query, Number of columns in table

Not applicable

25559

SSCE_M_INVALID_INDEX_HINT_ORDINAL

Invalid index ordinal in index hint specification.

Index ordinal

Not applicable

25560

SSCE_M_INVALID_INDEX_HINT_NAME

Invalid index name in index hint specification.

Not applicable

Index name

25561

SSCE_M_INVALID_QUERY_HINT_OPTION

Invalid query hint specification.

Not applicable

Not applicable

25562

SSCE_M_QP_INVALIDPERCENTSPEC

Percentage of rows to be sampled should be an integer between 1 and 100.

Not applicable

Table Name

25563

SSCE_M_QP_STATS_ALREADY_EXIST

There are already statistics existing on this index.

Not applicable

Table Name, Index Name

25565

SSCE_M_QP_STATS_NOT_EXIST

Statistics on this index do not exist.

Not applicable

Table Name, Index Name

25567

SSCE_M_QP_STATS_TABLE_TOO_SMALL

Table has too few rows to build statistics.

Not applicable

Table Name

25568

SSCE_M_QP_INVALID_STATS_OPTION

Invalid statistics creation option.

Not applicable

Statistics option

25569

SSCE_M_QP_INVALID_SET_OPTION

Invalid set option.

Not applicable

Set option

25571

SSCE_M_QP_ORDERBY_NOT_IN_SELECT_DISTICT

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Not applicable

Not applicable

25572

SSCE_M_QP_MULTIPLE_SETSHOWPLAN_IN_BATCH

The SET SHOWPLAN statements must be the only statements in the batch.

Not applicable

Not applicable

25573

SSCE_M_QP_MISMATCHEDPARAMETERTYPE

Query cannot use both named and unnamed parameters at the same time.

Not applicable

Not applicable

25574

SSCE_M_QP_DUPLICATEPARAMETERNAME

Duplicated parameter names are not allowed.

Not applicable

Parameter name

25575

SSCE_M_QP_ONLY_IN_FROM

Index hints are only allowed in a FROM clause.

Not applicable

Not applicable

25576

SSCE_M_QP_BAD_LOCK_HINT

Unrecognized LOCK HINTS option.

Not applicable

Not applicable

25577

SSCE_M_QP_ONLY_IN_SELECT

The NOLOCK lock hint is only allowed in a SELECT statement.

Not applicable

Not applicable

25578

SSCE_M_QP_CONFL_LOCKING

Conflicting locking hints specified.

Not applicable

Not applicable

25579

SSCE_M_QP_BAD_SET_STMT

Unrecognized SET statement.

Not applicable

Not applicable

25580

SSCE_M_QP_INVALID_SEEDINCREMENT_VALUE

Identity seed or increment value is invalid.

Not applicable

Not applicable

25582

SSCE_M_QP_ALTERTABLE_NONULL

Alter table only allows columns to be added which can contain null values. The column cannot be added to the table because it does not allow null values.

Not applicable

Not applicable

25584

SSCE_M_QP_COLUMNINUSE

The column could not be modified because one or more objects access this column.

Not applicable

Column name, Object Name (if available)

25585

SSCE_M_QP_QUERY_NOT_KEYSET_NO_TABLE

Cannot generate a keyset cursor for the query because there is no reference to base table.

Cursor Option

Not applicable

25586

SSCE_M_QP_QUERY_NOT_UPDATABLE_DISTINCT

Cannot generate an updatable cursor for the query because there is a DISTINCT operator.

Cursor Option

Not applicable

25587

SSCE_M_QP_CURSOR_NOT_UPDATABLE

Cursor is not updatable.

Not applicable

Not applicable

25588

SSCE_M_QP_COLUMN_NOT_UPDATABLE

Column is not updatable.

Not applicable

Name of column

25589

SSCE_M_QP_INVALID_LONG_VALUE_COLUMN

Internal error: This is not a base table long value column.

Not applicable

Not applicable

25590

SSCE_M_QP_INVALID_CURSOR_OPTIONS

The combination of cursor options is not valid. For instance updateable and insensitive is an invalid option.

Options specified

Not applicable

25591

SSCE_M_QP_INVALID_LONG_VALUE_OBJECT_ID

Internal error: The storage interface for long value is invalid or unsupported.

Not applicable

Not applicable

25592

SSCE_M_QP_INVALID_SETCOLUMN

SetColumn cannot be called during delete operation.

Not applicable

Not applicable

25593

SSCE_M_QP_BOOKMARK_NOT_SUPPORTED

Bookmark is not supported for this cursor.

Not applicable

Not applicable

25594

SSCE_M_QP_ALTERCOLUMN_LOB_INVALID

Cannot alter column of type NTEXT or IMAGE

Not applicable

Column Name

25595

SSCE_M_QP_QUERY_NOT_KEYSET_DISTINCT

Cannot generate a keyset cursor for the query because there is a DISTINCT operator.

Cursor Option

Not applicable

25596

SSCE_M_QP_QUERY_NOT_KEYSET_GROUPBY

Cannot generate a keyset cursor for the query because there is an explicit or implicit GROUP BY operator.

Cursor Option

Not applicable

25597

SSCE_M_QP_QUERY_NOT_KEYSET_OUTER_JOIN

Cannot generate a keyset cursor for the query because there is an OUTER JOIN operator.

Cursor Option

Not applicable

25599

SSCE_M_QP_QUERY_NOT_KEYSET_UNION

Cannot generate a keyset cursor for the query because there is a UNION operator.

Cursor Option

Not applicable

25600

SSCE_M_QP_QUERY_NOT_UPDATABLE_GROUPBY

Cannot generate an updatable cursor for the query because there is an explicit or implicit GROUP BY operator.

Cursor Option

Not applicable

25601

SSCE_M_QP_QUERY_NOT_UPDATABLE_OUTER_JOIN

Cannot generate an updatable cursor for the query because there is an OUTER JOIN operator.

Cursor Option

Not applicable

25602

SSCE_M_QP_QUERY_NOT_UPDATABLE_SORT

Cannot generate an updatable cursor for the query because there is a SPOOL/SORT operator.

Cursor Option

Not applicable

25603

SSCE_M_QP_QUERY_NOT_UPDATABLE_UNION

Cannot generate an updatable cursor for the query because there is a UNION operator.

Cursor Option

Not applicable

25604

SSCE_M_QP_QUERY_NOT_UPDATABLE_NON_STANDARD_JOIN

Cannot generate an updatable cursor for the query because there is a non-standard join expression.

Cursor Option

Not applicable

25605

SSCE_M_QP_QUERY_NOT_UPDATABLE_JOIN_GRAPH_CYCLE

Cannot generate an updatable cursor for the query because there is a cycle in join graph.

Cursor Option

Not applicable

25606

SSCE_M_QP_QUERY_NOT_UPDATABLE_11_KEY_ORDER

Cannot generate an updatable cursor for the query because a one-to-one join must compare columns in the same order as declared in unique indexes.

Cursor Option

Not applicable

25607

SSCE_M_QP_QUERY_NOT_UPDATABLE_MM

Cannot generate an updatable cursor for the query because there is a many-to-many relationship.

Cursor Option

Not applicable

25608

SSCE_M_QP_QUERY_NOT_UPDATABLE_NON_UPDATABLE_RELATIONSHIP

Cannot generate an updatable cursor for the query because there are one or more non-updatable relationships among base tables.

Cursor Option

Not applicable

25609

SSCE_M_QP_QUERY_NOT_UPDATABLE_DISCONNECTED_JOIN_GRAPH

Cannot generate an updatable cursor for the query because one or more tables are not explicitly joined together.

Cursor Option

Not applicable

25610

SSCE_M_QP_QUERY_NOT_UPDATABLE_SELF_JOIN

Cannot generate an updatable cursor for the query because there is a self join.

Cursor Option

Not applicable

25611

SSCE_M_QP_QUERY_NOT_UPDATABLE_NOT_SAME_COLUMNS

Cannot generate an updatable cursor for the query because updatable tables are not joined on the same columns.

Cursor Option

Not applicable

25612

SSCE_M_QP_QUERY_NOT_UPDATABLE_NO_UPDATABLE_COLUMN

Cannot generate an updatable cursor for the query because there is no updatable column.

Cursor Option

Not applicable

25613

SSCE_M_QP_FTOA_OVERFLOW

A conversion from float to string data failed.

Not applicable

Not applicable

25614

SSCE_M_QP_MISSINGPROCEDUREPARAMETER

Procedure expects parameter, which was not supplied.

Not applicable

Procedure Name, Parameter Name

25615

SSCE_M_QP_SCHEMAHASCHANGED

The table schema has changed since the query was last compiled. Recompile the query.

Not applicable

Table Name

25616

SSCE_M_QP_STATS_NOT_SUPPORTED

Statistics not supported on system tables.

Not applicable

Table Name

25617

SSCE_M_QP_INVALID_INDEX_OPTION

Invalid option specified in CREATE INDEX statement.

Not applicable

Option Name

25618

SSCE_M_QP_INVALID_STORED_PROC_NAME

Invalid stored procedure name.

Not applicable

Stored Proc Name

25619

SSCE_M_QP_FULLSCAN_REQUIRED

FULLSCAN option is required for CREATE/UPDATE STATISTICS.

Not applicable

Not applicable

25620

SSCE_M_QP_NAMED_CONSTRAINT_NOT_SUPPORTED

Named Constraint is not supported for this kind of constraint.

Not applicable

Constraint Name

25621

SSCE_M_QP_INVALIDPROCEDUREARGS

The specified argument value for the procedure is not valid.

Argument #

Name of procedure (if known)

25622

SSCE_M_QP_INVALIDTABLENAME

The table name is not valid.

Not applicable

Table Name

25623

SSCE_M_QP_INVALID_GLOBAL_VARIABLE_NAME

The global variable name is not valid.

Not applicable

Global variable Name

25624

SSCE_M_QP_INVALID_CREATE_DATABASE_OPTION

Invalid CREATE DATABASE option.

Not applicable

Option

25625

SSCE_M_QP_NODEFAULTONROWVERCOL

Defaults cannot be created on row version columns.

Not applicable

Table name, Column name

25626

SSCE_M_QP_ALTERCOLUMN_SRC_TIMESTAMP_INVALID

Cannot alter column of type TIMESTAMP/ROWVERSION

Not applicable

Column name

25628

SSCE_M_QP_NO_ORDERBY_WITHOUT_TOP_IN_SUBQUERY

The ORDER BY clause is invalid in subqueries unless TOP is also specified.

Not applicable

Not applicable

25629

SSCE_M_QP_INVALID_TOP_VALUE

The number of rows in the TOP clause must be a positive integer.

Not applicable

Not applicable

25630

SSCE_M_QP_INVALID_TOP_EXPRESSION

Invalid expression in the TOP clause. Provide an integer constant, expression on constants or parameter.

Not applicable

Not applicable

25632

SSCE_M_QP_NOCOL_ALIAS_IN_SUBQUERY

Column names must be specified for constants, expressions or aggregate functions when they occur in a FROM subquery.

Not applicable

Not applicable

25633

SSCE_M_QP_MULTIPLE_COL_SPEC

Column name was specified multiple times for a subquery.

Not applicable

Column name, Alias of subquery

25634

SSCE_M_QP_CORRELATED_AGGR_IN_APPLY

Aggregates on the right side of an APPLY cannot reference columns from the left side.

Not applicable

Not applicable

25635

SSCE_M_QP_ALTERCOLUMN_TGT_TIMESTAMP_INVALID

Cannot alter column to be type TIMESTAMP.

Not applicable

Column name

25636

SSCE_M_QP_CONSTEXPR_IN_GROUP_BY

Each GROUP BY expression must contain at least one column that is not an outer reference.

Not applicable

Not applicable

25900

SSCE_M_QP_BADEXPR

The query processor encountered an error evaluating the expression.

Not applicable

Not applicable

25901

SSCE_M_QP_OVFLO

Expression evaluation caused an overflow.

Not applicable

Name of function (if known)

25902

SSCE_M_QP_EXPRTYPECHECK

The data types in the IN expression do not match.

Not applicable

Not applicable

25903

SSCE_M_QP_DATEPART

There was an error in a part of the date format.

Not applicable

Expression (if known)

25904

SSCE_M_QP_DATEABORT

There was an error in the date format.

Not applicable

Expression

25905

SSCE_M_QP_SYNTAX

There was a syntax error in the date format.

Not applicable

Expression

25906

SSCE_M_QP_CONVSYNTAX

There was a syntax error while converting from one data type to another.

Not applicable

Expression

25907

SSCE_M_QP_MONEYOVERFLOW

An overflow occurred while converting the string data type to money.

Not applicable

String

25909

SSCE_M_QP_NOCOLUMNREFINDEFAULT

Default values cannot have column references.

Not applicable

Not applicable

25910

SSCE_M_QP_NOAGGRINDEFAULT

Default values cannot have aggregate functions.

Not applicable

Not applicable

25911

SSCE_M_QP_NOAGGRONLOB

Aggregate value expressions cannot have ntext or image data.

Not applicable

Not applicable

25912

SSCE_M_QP_NOCONVDUETOTRUNC

The original data is truncated and cannot be converted.

Not applicable

Not applicable

25913

SSCE_M_QP_ARITHOPNOTSUPPORTED

The arithmetic operator is not supported for the data type.

Not applicable

Not applicable

25914

SSCE_M_QP_NOMODULOSUPPORT

Modulo is not supported on real, float, money, and numeric data types.

Not applicable

Data type

25916

SSCE_M_QP_SUBQUERYINVALIDOP

An operator on the result data type from a subquery is not valid.

Not applicable

Not applicable

25917

SSCE_M_QP_NOBITOPSUPPORT

Bit operators (&,|,^,~) are not supported on real, float, money, and numeric data types.

Not applicable

Data type

25918

SSCE_M_QP_BADARITHTYPE

The data type is not valid for the arithmetic operation.

Not applicable

Data type (if known)

25920

SSCE_M_QP_TRUNCATION

The data was truncated while converting from one data type to another.

Not applicable

Name of function (if known)

25921

SSCE_M_QP_INVALIDFUNCTIONNAME

The function is not recognized by SQL Server Compact.

Not applicable

Name of function, Data type (if known)

25922

SSCE_M_QP_INVALIDFUNCTIONARGS

The specified argument value for the function is not valid.

Argument #

Name of function (if known)

25923

SSCE_M_QP_NOSUPPORTFORLOB

The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE or IS NULL predicates.

Not applicable

Not applicable

25924

SSCE_M_QP_BINDTSYNTAX

An overflow has occurred while converting binary to datetime.

Not applicable

Not applicable

25925

SSCE_M_QP_NUMDTSYNTAX

An overflow has occurred while converting numeric to datetime.

Not applicable

Not applicable

25926

SSCE_M_QP_MONDTSYNTAX

An overflow has occurred while converting money to datetime.

Not applicable

Not applicable

25927

SSCE_M_QP_BIGINTDTSYNTAX

An overflow has occurred while converting bigint to datetime.

Not applicable

Not applicable

25928

SSCE_M_QP_TOOMANYARGS

There are too many arguments specified for the procedure or function.

Count of arguments

Not applicable

25929

SSCE_M_QP_UMINUSNUMONLY

A unary minus can be performed only on tinyint, smallint, int, bigint, money, and numeric data types.

Not applicable

Not applicable

25930

SSCE_M_QP_PRECISIONMISMATCH

The operation cannot be performed because the precision of the numeric data types do not match.

Precision of right data type (if known), Precision of left data type (if known)

Not applicable

25931

SSCE_M_QP_SCALEMISMATCH

The operation cannot be performed because the scale of the numeric data types do not match.

Scale of right data type (if known), Scale of left data type (if known)

Not applicable

25932

SSCE_M_QP_NOIMPLICITCONVALLOWED

The data types cannot be converted implicitly.

Not applicable

Source data type, Destination data type

25933

SSCE_M_QP_DATETIMEOVFLO

An overflow occurred while converting to datetime.

Not applicable

Not applicable

25935

SSCE_M_QP_DIVBYZERO

Dividing by zero is not allowed.

Not applicable

Name of function (if known)

25937

SSCE_M_QP_NOTIMEPARTSPECIFIED

A time datepart must be specified to convert a string to datetime.

Not applicable

String

25938

SSCE_M_QP_INVALIDHOURTIMEPARTSPECIFIED

The specified hour in the time datepart is not valid.

Not applicable

String

25939

SSCE_M_QP_INVALIDMINUTETIMEPARTSPECIFIED

The specified minute in the time datepart is not valid.

Not applicable

String

25940

SSCE_M_QP_INVALIDSECONDIMEPARTSPECIFIED

The specified second in the time datepart is not valid.

Not applicable

String

25941

SSCE_M_QP_INVALIDMSEDCONDIMEPARTSPECIFIED

The specified millisecond in the time datepart is not valid.

Not applicable

String

25942

SSCE_M_QP_SYNTAXERRORINDATETIMESTRING

The specified date or time datepart is not valid.

Not applicable

String

25943

SSCE_M_QP_FORMATERRORINDATETIMESTRING

The format of the specified date or time datepart is not valid.

Not applicable

String

25944

SSCE_M_QP_INVALIDORDERINDATETIMESTRING

The order of the specified date or time datepart is not valid.

Not applicable

String

25945

SSCE_M_QP_INVALID_ESCAPE_SEQUENCE

The escape sequence used in the LIKE predicate is not valid.

Not applicable

Not applicable

25946

SSCE_M_QP_INVALIDFUNCTIONARGNUM

The number of arguments specified for the function is not correct.

Minimum argument count, Maximum argument count

Name of function (if known)

25947

SSCE_M_QP_INVALIDCONVERSION

The conversion is not supported.

Not applicable

Type to convert from (if known), Type to convert to (if known)

25948

SSCE_M_QP_INVALIDFUNCTIONARGVALUE

The specified argument value for the function is not valid.

Not applicable

Name of function (if known)

25949

SSCE_M_QP_INCOMPATIBLE_TYPES

The expressions in UNION are not compatible.

Expression ordinal, Type of left expression

Type of right expression

25950

SSCE_M_QP_MISSINGPARAMETER

A parameter is missing.

Parameter ordinal

Not applicable

25951

SSCE_M_QP_PARAMETERNOTALLOWED

A parameter is not allowed in this location. Ensure that the '@' sign and all other parameters are in a valid location in the SQL statement.

Not applicable

Not applicable

25953

SSCE_M_QP_SIGNMISMATCH

Expression evaluation caused a sign mismatch.

Not applicable

Not applicable

25954

SSCE_M_QP_CANNOTALTERCOLUMNWITHDEFAULT

Cannot alter column because it has a default value.

Not applicable

Column Name

25955

SSCE_M_QP_BAD_BOOL_OP_TYPE

The data type is not valid for the Boolean operation.

Not applicable

Data type (if known), Data type (if known)

25956

SSCE_M_QP_MISSINGPARAMETERTYPE

Parameter type has not been declared.

Parameter Ordinal

Parameter Name (if available)

25957

SSCE_M_QP_LOB_IN_UNION_DISTINCT

The ntext and image data types can be used in select list of UNION only when ALL option is specified.

Not applicable

Not applicable

26100

SSCE_M_QP_BADTABLE

The table name is not valid.

Token line number (if known), Token line offset (if known)

Table name

26302

SSCE_M_QP_BADTYPE

The specified data type is not valid.

Not applicable

Data type (if known)

26303

SSCE_M_QP_INTERNAL

Internal error: A query processor error occurred.

Not applicable

Not applicable

26305

SSCE_M_QP_BADADTMETAINFO

The DDL statement contains invalid parameters associated with the column definition.

Not applicable

Not applicable

26306

SSCE_M_QP_COERSIONERROR

Data conversion failed.

OLE DB status value (if known)

Not applicable

26307

SSCE_M_QP_BADQUERY

Syntax error in query.

Not applicable

Not applicable

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft