I hope that gives you some avenues to try if you are finding that Intelli Sense isn't working (partially or at all).And if you've shied away from Intelli Sense in SSMS 2008 or SSMS 2008 R2, I hope you'll give it another shake in SSMS 2012.
Intelli Sense can be a very powerful ally for the T-SQL developer.
It can significantly reduce keystrokes, prevent you from guessing at object names, make sure you spell them correctly (and use the right case), and can help you understand the interface to several programmable entities such as stored procedures and built-in functions.
So, this post is about our beloved IDE instead of actual code. Note that you can now kiss your Visual Studio 2010 settings and preferences goodbye (your projects will be safe and sound). DELETE (or rename) all other folders that are not the “11.0” folder, assuming you used to have Visual Studio 2008 or whatever.
I recently upgraded my home PC from Visual Studio 2010 and 11 Beta to Visual Studio 2012. ” and then, after a swig of beer, proceeded to exercise my Google-Fu to solve this issue. Here you’ll see a folder titled “11.0” (the VS 2012 folder) and probably also “10.0” (the VS 2010 folder). Now restart Visual Studio 2012 and you should be good to go!
Note that most of these items are also applicable to previous versions.
There are a couple of different symptoms that can lead you to believe that Intelli Sense is "not working." One is where the Intelli Sense features (auto-complete / list members / tool-tips / underlining invalid references) do not function at all.Perturbed by this situation, I set out on a (very short) quest to find out how to fix this.As you can see below, the dot after my Xml Node type towns didn’t pop up the intellisense menu.The very first thing I noticed was that after about 10 minutes of programming my Intellisense quit working and never came back. Strangely, I did not find the “correct” aka permanent solution to this problem. So, after a ton of screwing around and guess-and-check, here’s how I solved it. There are topics for other versions of SQL Server as well: SQL Server 2008 | SQL Server 2008 R2.