Error 207
Severity Level 16
Message Text
Invalid column name '%.*ls'.
Explanation
This error occurs when a column referenced in a Transact-SQL statement was not found in any table specified in the FROM clause of the query.
Action
Change the column name to a column name present in one of the tables referenced in the query.
This example returns error 207:
USE Northwind
GO
SELECT CategoryName1
FROM Categories
GO
Evaluate the problem by looking at the full command. For the above example, ensure that the SELECT statement contains the name of a valid column name (CategoryName rather than CategoryName1 as specified above) for the specified table.
USE Northwind
GO
SELECT CategoryName
FROM Categories
GO