SQL Server 2008 and Management Studio - Intellisense is Patchy
It should revive when you refresh it's cache. In the menu is Edit - Intellisense - Refresh Local Cache (ctrl+shift+r). Or you can use another auto complete client like SQL Prompt or SQL Complete. First one has only paid version, while the second has also a free version.