title: SQL Server 2008 R2 intellisense not working
body: <p>Just started a new job and everything was already installed on my machine.
  It's not exactly a friendly bunch. (early days)</p>
  
  <p>I have SQL Server 2008 R2 and I see I have Visual Studio 2010 SP1.</p>
  
  <p>I don't have any intellisense in SQL Server Management Studio.</p>
  
  <p>Googled and found hundreds of hits!!!</p>
  
  <p>Ultimately I have found this link:</p>
  
  <p><a href="http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&amp;kbln=en-us#step1" rel="noreferrer">http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&amp;kbln=en-us#step1</a></p>
  
  <p>The problem is I have so many hotfixes to choose from and I don't know which one
  Do you know?</p>
  
  <p><img src="https://i.stack.imgur.com/NnvZI.png" alt="enter image description here"></p>
  
  <p>thanks a lot</p>