While writing my SQL code in a New Query (connection established to the server of course), every once and a while it will stop recognizing my table/column/object names as existing in my database and highlight them with the red squiggly line. (As well as the same names that were previously recognized in code that had been typed before).
However, most of the time when I execute the query it goes through and runs just fine and ignores its own warnings. Other times it will throw me errors like "multi-part identifier could not be bound." The same goes for the drop down auto complete list that appears when I begin typing the name. When this happens, only the database shows and none of the tables/columns/procedures stored.
Sometimes exiting and restarting MS SSMS fixes things, sometimes disconnecting and reconnecting from the server (running on same machine) fixes it, and other times I need to restart the laptop.
I don't think it has anything to do with my coding since I can literally copy and paste the "flawed" code, restart, then repaste it and it will work just fine.
At this point, even typing the following short line of code throws the error "Multi-part identifier could not be bound"
USE INVDATA IF COMPLETE_RECORDS.ITM_NUM <> 0 [INDENT]BEGIN [INDENT]PRINT 'NOPE;[/INDENT] END[/INDENT]
Is it something I'm doing or what could be the possible issue?