Red squiggly error-underlines in TSql code, but no real error? 1

[jsteph]

Hi all,
First, I know I can turn of those red underlines in the Options/TSql/Intellisense.

I don't want to ignore the "error" I want to know why it says it's an error when I don't think there's an error.

The "error" is when I type a simple SELECT statement the table and fieldnames get this red underline and the mouse-hover error says "invalid object name blah, blah".

It's not an invalid name, it's in the db I'm working in, the one showing in the little window up by the Execute button is.

I'm logged onto SMS under Windows Auth. as and admin user of the server. All server roles are checked for this Windows user account in the Logins section of SMS.

The user wasn't a user of the db I was working on but I even added this user to that db and gave him dbowner.

Still with the error squigglys. Many other tables in this db do not give this error (this is a newly created table, created under this SMS session, by this user. I tried "Refresh" at every tree-level in SMS. I disconnected and re-connected. I tried prefixing with dbo. and this table doesn't show up in intellisense but I can run any sort of DML operation on it.

Why the false error?
Thanks,
--Jim

 

[gmmastros]

Take a look at this:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/01/why-is-intellisense-not-working.aspx

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[jsteph]

Ctrl-Shift-R did it, thanks!

I just don't understand why at the very least it wouldn't refresh that when you hit the "Refresh" right-click option on any set of objects. Mine is not to wonder why.
--Jim