I love new SSDT (SQL Server Data Tools) product from Microsoft. I blogged about it a few times already. One thing that was bugging me though is the face that IntelliSense was not working for me at all. I have been ignoring that for a while being that I am busy and the fact that I could compose my stored procedures in SQL Server Management Studio if I had to.
I finally took a minute to figure out why, and the answer was dead simple. For some reason the feature was disabled in options. To enable it go to Tool -> Options menu in Visual Studio, expand Text Editor, then find SQL Server tools, then check option on General and IntelliSense nodes.
Hopefully I just saved someone a few minute of headache.