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.

Enjoy.