MS SQL Intellisense for Columns not Working for Some Tables 2008 R2
===

I am having some troubles with intellisense in SQL Server 2008 R2.

Intellisense for all tables works fine, but the column intellisense only seems to work for some tables.

For example, this query pulls up a list of all the functions and navigates to the items starting with "sta":

    select *
    from tbl_cash_stats
    where sta

This query doesn't pull up anything after the where clause regardless of if I type any characters or not

    select *
    from tbl_assignment
    where 

Furthermore, if I join a table that is working properly with one that is not, no column-level intellisense works:

    select *
    from tbl_cash_stats
    join tbl_assignment
	    on 

I have refreshed local cache several times with no success. There appears to be no specific reason why certain tables work perfectly and others do not, and only about 15% of the tables are affected.

Does anyone have an idea of how to fix this? It has become extremely annoying because it is affecting some of the tables I use most often.