Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_207

SQL Server 2005

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft