I see people complain that IntelliSense (new in SQL Server 2008's Management Studio) is not working. Most of the time, it is for one of two reasons:
Little did I know, there are a number of other situations where IntelliSense will not function correctly (e.g. when you have switched to SQLCMD mode). I was also unaware, until today, that Alan Brewer at Microsoft created a Books Online page that documents these and other cases:
So many thanks for this document Alan, as I think it will help others as well. What I'm still trying to figure out, though, is why there is a SQL Server 2005 version of the page, since IntelliSense does not exist in Management Studio for 2005, nor does it work in 2008 against 2005 instances.