Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 View Error

Author  Topic 

dtrivedi
Posting Yak Master

153 Posts

Posted - 2011-03-09 : 08:51:31
I am trying to run a view and i'm getting this error...there is a coulumn named isnewonly what does the 2nd error message 4413 mean

Msg 207, Level 16, State 1, Procedure vw_PreferenceHeader, Line 5
Invalid column name 'isnewonly'.
Msg 4413, Level 16, State 1, Line 27
Could not use view or function 'SCP.dbo.vw_PreferenceHeader' because of binding errors.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-03-09 : 08:53:46
It means that the underlying schema behind the view has changed...the column "isnewonly" does not exist in the table the view is referring to.

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

dtrivedi
Posting Yak Master

153 Posts

Posted - 2011-03-09 : 09:51:55
thank you
Go to Top of Page
   

- Advertisement -