Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I hear from database developers (especially those who have migrated from .NET) is that the intellisense seems to miss some recently created objects. They cry out "My object doesn't appear in the drop down".

Well, I am not an Intellisense internals guy, but I will share with you the most common fix for this problem. If you click on CTRL-SHFT-R or Edit > Intellisense > Refresh Local Cache this will likely take care of your issue. See Below and happy coding !

Don't forget to post your thoughts or email me your questions to ajorgensen@pragmaticworks.com. As always, this Blog is to help you better understand the tools at your disposal ...