IntelliSense Not Working in Microsoft SQL Server Management Studio/Express 2008?
There are a batch of reasons why the new IntelliSense feature of Microsoft's 2008 SQL Server Management Studio (and the Express version) doesn't work. I'm not going to get into all of them here as there is already an article about this on Microsoft's site here . But without changing settings, or modes, I bet the most common reason is the one I ran into - connecting to SQL Server/Desktop instances prior to the 2008 version (version 10.x). The IntelliSense feature requires a minimum of a 2008 engine. I have three different SQL instances that I use a lot and they are all the older engines - so no IntelliSense with the 2008 SQL Server Management Studio Express editor! 8( So, I'll probably be upgrading those engines soon....