There may be times when Intelli Sense in SQL Server Management Studio 2008 is not working or does not display the latest schema changes.
To resolve these issues you can follow the below solution.
Vishwanath Dalvi is a gifted engineer and tech enthusiast. When not hacking around or supporting the open source community, he is trying to overcome his phobia of dogs.
Another is where the completion list appears, but it does not contain the object(s) you're trying to use.
SQL Server 2012 Books Online outlines a variety of other potential issues in the topic Troubleshooting Intelli Sense (SQL Server Management Studio).
Sometimes Intelli Sense does not work when using SQL Server Management Studio 2008. Step 1: Go to Tools Intelli Sense and make sure the Enable Intelli Sense checkbox is checked Step 2: To verify that it is enabled, go to the Query menu and check that Intelli Sense is enabled as shown below.
Metadata in SSMS isn't updating unless I shut it down and restart.