

The steps mentioned in this article are applicable across SQL Server 2008 Management Studio, SQL Server 2008 R2 Management Studio, SQL Server 2012 Management Studio, SQL Server 2014 Management Studio, and SQL Server 2016 Management Studio.


The fix mentioned in this article is applicable for SSMS 2008 and higher versions. During such scenarios, one can follow the below-mentioned steps to refresh the IntelliSense feature of SQL Server Management Studio (SSMS). It can compile either in C mode or C++ mode. However, there are certain occasions when the IntelliSense feature in SSMS doesn’t work. Microsoft Visual C++ is Microsofts partial implementation of the C and full implementation C++ compiler and associated languages-services and specific tools for integration with the Visual Studio IDE. IntelliSense feature reads internal metadata and lists all of the available objects and its properties, thereby helping Database Developers, DBAs effectively and quickly write TSQL scripts. What is IntelliSense feature and how it can help? In this tip, we will take a look at the steps you can follow to quickly enable and refresh IntelliSense in SSMS to resolve this issue of IntelliSense not displaying the latest schema changes. As a Developer or as a DBA you may face issues with IntelliSense feature not to be working or not displaying latest scheme changes when you are writing TSQL code within the Query Window of SQL Server Management Studio (SSMS). In SQL Server 2008, Microsoft had introduced IntelliSense feature in SQL Server Management Studio (SSMS).
