The ability to add new smart hints to SQL Server 2008r2 simplifies input and is very handy. But suddenly one day the smart tip is gone, so depressed!
Toss for half a day finally will smart tips to find back, the following is my solution to the problem of thinking:
1. Enable IntelliSense is turned on in the View Tools option?
Select Tools-->options to open the Options page, expand text editor-->transact-sql-->intellisense to display the configuration page shown in the following figure, and check to see if the Enable IntelliSense options. Note Changing the configuration to open a new query page will not work.
If the check still doesn't work, proceed to the next step.
2. If the previous enable IntelliSense has been checked, it is possible that the cache is fully occupied.
Select Menu Edit-->intellisense-->refresh local cash empty cache.
3. Generally after the above two steps can be, but I still do not work.
The Internet query found that there were hints that if the smart tip disappears after you install the visual Studio SP1 patch, you need to install SQL Server 2008r2 SP1.
Although I did not install visual Studio SP1, I recently installed Team Explorer 2008, which is the same problem. Download SQL Server 2008r2 SP1 After installation The problem is solved.
Download Address: http://www.microsoft.com/en-us/download/details.aspx?id=26727