Invalid column name SQL Server bug

Question

Hi there,

I have a stored procedure that is throwing an 'Invalid column name' error for 'ContentMarginExVat';

SELECT  CategoryTitle, ContentID, ContentTitle, ContentMarginExVat, ContentWeight
FROM    VWProductsCurrent
WHERE   ContentID = @ContentID

I have checked both the VWProductsCurrents and the associated table that gets the data, both of these have the ContentMarginExVat selected, but yet the SQL Server Management Studio 2008 still says that the Column has an invalid name.

Wondered if anyone might be able to offer any advice on this?

Thank you.

Answer 1

You need to run

exec sp_refreshsqlmodule 'VWProductsCurrent'

to refresh the metadata held about the view.

Answer 2

Try to execute this query and copy the column name to your query:

select 
  name 
from
  sys.columns 
where
  object_id = object_id('VWProductsCurrent')

or try to recompile your stored procedure with:

exec sp_recompile 'your_proc_name'