SQL Server IntelliSense IntelliSense does not work

Don't know what's going on, suddenly SQL Server does not pop up smart hints, try the following methods

Method one turn from http://www.jb51.net/article/30822.htm result: Wood has solved

The ability to add new smart hints in SQL Server 2008r2 simplifies input and makes it easy. But suddenly one day smart tips No, good depressed!

Toss a half-day finally will be smart tips to find back, below is my idea of solving this problem:

1. See if Enable IntelliSense is turned on in the tool options?

Select Tools-->options to open the Options page, expand the text editor-->transact-sql-->intellisense display the configuration page as shown, and check whether the Enable IntelliSense option. Note You will have to open a new query page after you modify the configuration to work.

If the tick still does not work then proceed to the next step.

2. If the previous enable IntelliSense is checked, it is possible that the cache is fully occupied.

Select Menu Edit-->intellisense-->refresh Local cash Empty the cache.

3. In general, after the above two steps can be, but my still does not work.

After surfing the internet, it is suggested that the smart hints will disappear if a patch for visual Studio SP1 is installed, requiring the installation of SQL Server 2008R2 SP1.

Although I did not install visual Studio SP1, I recently installed Team Explorer 2008 to come up with the same problem. After you download the SQL Server 2008R2 SP1 installation issue is resolved.

: http://www.microsoft.com/en-us/download/details.aspx?id=26727

Method Two: Turn from http://www.cnblogs.com/Theladyflower/archive/2013/05/21/3090328.html solves the problem

Sometimes it is found that the intelligent perception of SQL Server does not work, and you can try to solve it by following these methods:

1. Ensure the correct turn on IntelliSense

Enabled: (Auto List members)

2. For some newly created object, it is not possible to intelligently prompt, can be resolved by refreshing the local cache method:

SQL Server IntelliSense IntelliSense does not work