TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

MSSQLSERVER_207

New: 17 November 2008

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

207

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

Message Text

Invalid column name '%.*ls'.

The specified column was not found in any table specified in the FROM clause of the query.

  • Change the column name to a column name present in one of the tables referenced in the query.
  • Verify the collation of the database. When a database uses a case-sensitive collation, the column names specified in the Transact-SQL statement must match the case of the columns in the database.
    For example, when a column is specified as LastName and the database uses a case sensitive collation, queries that refer to the column as Lastname or lastname will cause error 207 to return because the column name does not match.
    You can verify the database collation by running the following statement.
    SELECT collation_name FROM sys.databases WHERE name = 'database_name';
    The abbreviation CS in the collation name indicates the collation is case sensitive. For example, Latin1_General_CS_AS is a case sensitive and accent sensitive collation. CI indicates the collation is case-insensitive.
Show:
© 2016 Microsoft