4104

Product Name

Event ID

4104

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

ALG_MULTI_ID_BAD

Message Text

The multi-part identifier ”%.*ls” could not be bound.

The name of an entity in SQL Server is referred to as its

identifier. You use identifiers whenever

you reference entities, for example, by specifying column and table names in a query. A multi-

part identifier contains one or more qualifiers as a prefix for the identifier. For example, a table

identifier may be prefixed with qualifiers such as the database name and schema name in

which the table is contained, or a column identifier may be prefixed with qualifiers such as a

table name or table alias.

Error 4104 indicates that the specified multi-part identifier could not be mapped to an existing

entity. This error can be returned under the following conditions:

The qualifier supplied as a prefix for a column name does not correspond to any table or

alias name used in the query.

For example, the following statement uses a table alias (

) as a column prefix, but the

table alias is not referenced in the FROM clause.

ﾉ

Expand table

Dept
SELECT Dept.Name FROM HumanResources.Department;