Msg 207, Level 16, State 1, Line 1 Invalid column name ‘names’.

Error Message:

Msg 207, Level 16, State 1, Line 1
Invalid column name ‘names’.

Fix/Resolution:
1) Use correct alias names in your tsql code
2) Check if the column name exists in the table (or) Table valued function.
3) If the metadata is recently updated use sp_refreshsqlmodule to update metadata of the non schema bound objects.

Leave a Reply

Your email address will not be published. Required fields are marked *