Everybody is enjoying with new SQL Server 2008 intellisense feature. At the same time you would have wondered that it is not working with new tables, views, stored procedures created. This is due to cache refresh issue with SQL Server 2008 and you can simply refresh the cache as explained below.

I have added new table “Active Reports”, but it is not showing up in the SQL Intellisense.

Even if you type the sql query analyzer shows as error, even if you execute the query it will not show error and you will be blaming the intellisense feature.

Now, go to SQL Menu Edit -> IntelliSense -> Refresh Local Cache (Ctrl+Shift+R), the intellisense detected the table as shown below.

Hope this helps to the new comers of SQL 2008