{"id":204,"date":"2012-05-14T08:10:49","date_gmt":"2012-05-14T08:10:49","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/14\/msg-207-level-16-state-1-line-1-invalid-column-name-names\/"},"modified":"2012-05-14T08:10:49","modified_gmt":"2012-05-14T08:10:49","slug":"msg-207-level-16-state-1-line-1-invalid-column-name-names","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/14\/msg-207-level-16-state-1-line-1-invalid-column-name-names\/","title":{"rendered":"Msg 207, Level 16, State 1, Line 1 Invalid column name &#8216;names&#8217;."},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<font color=\"red\"><br \/>\nMsg 207, Level 16, State 1, Line 1<br \/>\nInvalid column name &#8216;names&#8217;.<br \/>\n<\/font><\/p>\n<p><strong>Fix\/Resolution:<\/strong><br \/>\n1) Use correct alias names in your tsql code<br \/>\n2) Check if the column name exists in the table (or) Table valued function.<br \/>\n3) If the metadata is recently updated use <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb326754.aspx\">sp_refreshsqlmodule<\/a> to update metadata of the non schema bound objects.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error Message: Msg 207, Level 16, State 1, Line 1 Invalid column name &#8216;names&#8217;. 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&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1940,128],"tags":[1941,1942],"class_list":["post-204","post","type-post","status-publish","format-standard","hentry","category-msg-207","category-sql-errors","tag-invalid-column-name-sql-server-2008","tag-msg-207-level-16-state-1-line-1"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=204"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/204\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}