107

Product Name

Event ID

107

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

P_NOCORRMATCH

Message Text

The column prefix ’%.*ls’ does not match with a table name or alias name used in the

query.

The select list of the query contains an asterisk (*) that is incorrectly qualified with a column

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

The column prefix does not correspond to any table or alias name used in the query. For

example, the following statement uses an alias name (

) as a column prefix, but the alias

is not defined in the FROM clause.

A table name is specified as a column prefix when an alias name for the table is supplied

in the FROM clause. For example, the following statement uses the table name

as the column prefix; however, the table has an alias (

) defined in the FROM clause.

ﾉ

Expand table

T1
ErrorLog
T1
SELECT T1.* FROM dbo.ErrorLog;