I am really new in this IT field and in my project I faced this problem in experiencing frequent invalid object and column name, even thought there is no syntax error whatsoever in my sql statement.
After a few hours, the invalid objects will be gone.
However, it's really disturbing for me, as I am constantly wondering if the Stored Procedure created can be used.
I was told to either refresh the table or create an insert statement everytime to test things out.
Is this the way how SQL 2008 behave ? I mean it is really to use something that is so unstable.
Please see attached picture -- one that has invalid object and a similar one but with the invalid object gone after a few hours.
Really hope to have honest opinion on this.
The system is not local. I am given a username and password to access a server database.