8632

Product

Name

Event ID

8632

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

QUERY_EXPRESSION_TOO_COMPLEX

Message Text

Internal error: An expression services limit has been reached. Please look for potentially

complex expressions in your query, and try to simplify them.

Error 8632 is raised when you run a query in SQL Server that contains a large number of

identifiers and constants in a single expression. An error message like the following is reported

to the user:

Server: Msg 8632, Level 17, State 2, Line 1

Internal error: An expression services limit has been reached. Please look for potentially

complex expressions in your query, and try to simplify them.

This issue occurs because SQL Server limits the number of identifiers and constants that can be

contained in a single expression of a query. This limit is 65,535. For example, the following

query only has one expression:

ﾉ

Expand table