Rajan's Blog - SQL Server 2008 http://blog.rajan.net.in/ Experience Talks en-us Rajan R.G Sun, 29 Mar 2009 06:45:14 GMT newtelligence dasBlog 2.3.9074.18820 rgrajan@gmail.com rgrajan@gmail.com http://blog.rajan.net.in/Trackback.aspx?guid=84bf6e1f-9210-4bdf-945c-37750390156b http://blog.rajan.net.in/pingback.aspx http://blog.rajan.net.in/PermaLink,guid,84bf6e1f-9210-4bdf-945c-37750390156b.aspx Rajan R.G http://blog.rajan.net.in/CommentView,guid,84bf6e1f-9210-4bdf-945c-37750390156b.aspx http://blog.rajan.net.in/SyndicationService.asmx/GetEntryCommentsRss?guid=84bf6e1f-9210-4bdf-945c-37750390156b

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.

sql-intellisense1

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

sql-intellisense2

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.

sql-intellisense3

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

sql-intellisense4

Hope this helps to the new comers of SQL 2008

SQL Server 2008 Intellisense Refresh http://blog.rajan.net.in/PermaLink,guid,84bf6e1f-9210-4bdf-945c-37750390156b.aspx http://blog.rajan.net.in/2009/03/29/SQLServer2008IntellisenseRefresh.aspx Sun, 29 Mar 2009 06:45:14 GMT <p> 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. </p> <p> <a href="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense1_2.jpg"><img style="border-right-width: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" border="0" alt="sql-intellisense1" src="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense1_thumb.jpg" width="244" height="98" /></a> </p> <p> I have added new table &#8220;Active Reports&#8221;, but it is not showing up in the SQL Intellisense. </p> <p> <a href="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense2_2.jpg"><img style="border-right-width: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" border="0" alt="sql-intellisense2" src="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense2_thumb.jpg" width="244" height="69" /></a> </p> <p> 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. </p> <p> <a href="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense3_4.jpg"><img style="border-right-width: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" border="0" alt="sql-intellisense3" src="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense3_thumb_1.jpg" width="244" height="173" /></a> </p> <p> Now, go to SQL Menu Edit -&gt; IntelliSense -&gt; Refresh Local Cache (Ctrl+Shift+R), the intellisense detected the table as shown below. </p> <p> <a href="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense4_2.jpg"><img style="border-right-width: 0px; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" border="0" alt="sql-intellisense4" src="http://blog.rajan.net.in/content/binary/WindowsLiveWriter/SQLServer2008IntellisenseRefresh_F505/sql-intellisense4_thumb.jpg" width="244" height="112" /></a> </p> <p> Hope this helps to the new comers of SQL 2008 </p> <img width="0" height="0" src="http://blog.rajan.net.in/aggbug.ashx?id=84bf6e1f-9210-4bdf-945c-37750390156b" /> http://blog.rajan.net.in/CommentView,guid,84bf6e1f-9210-4bdf-945c-37750390156b.aspx SQL Server 2008