Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

Hi,

You might have lost the Intellisense in ‘Sql server management studio 2008 R2’ after you installed Visual studio 2010 Sp1.

This is a known issue and it got fixed after I installed “Service Pack 1” of Sql server from below link

Download

When you click the above link, from the page download & install “SQLManagementStudio_x64_ENU.exe” and restart the machine

There might be other reasons for this and it explained in-detail in below article

Link

Hope it helps 🙂