CODEWITHSUNDEEP
sql-server-2012
Chad Portman
Chad Portman

Reputation: 1226

Invalid Column name but still working

When I connect to the server name using it's name SQL is showing red lines under the code and stating things like column invalid or object invalid. But the code stills runs. When I connect to the server using it's IP I do not get the red lines and the code also runs.

Can I trust the data when using the name? Also why is it doing this?

I am using SSMS 2012 to access a brand new 2012 server.

Upvotes: 2

Views: 1112

Answers (1)

SQL Taylor
SQL Taylor

Reputation: 138

Did you make the column since the last time you refreshed your local intellisense cache? Try doing that and seeing if it shows as valid.

Edit -> Intellisense -> Refresh Local Cache and then ctrl + Shift + R

Give that a shot and see if it works for you.

Upvotes: 5

Related Questions