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

Posted on : 14-05-2012 | By : Devi Prasad | In : Msg 207, SQL Errors

0



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.




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: ,