I was really enjoying one of SSMS 2008 new features - IntelliSense. But later it was "dissappearing" and "getting back" somehow. I was connecting to five different SQL server instances. And only two of them were the latest ones (2008). I did not paid much attention to that fact as had been using SSMS 2005 for a while which had no IntelliSense builtin support. The fact that something is not under my control was disturbing me so I started to google around.
The answer was very simple and unexpected. IntelliSense in SSMS 2008 does not work for down-level systems. Then I found an interesting blog post which stated that SSMS 2008 CTP5 and CTP6 had IntelliSense support for all SQL Server down versions. It appeared that there was some kind of defect in server version check logic that allowed IntelliSense to work with down level versions.
100% percent agree with blog post author that it would be nice to have IntelliSense working with all versions. :)
Regards,
Oleh
