With CTP5 release, comes intellisense in SSMS (SQL Server Management Studio). Here is an image depicting the basic functionality:
It is a really neat feature and can also help in learning the new objects in the system. A colleague of mine though absolutely hates it 🙂 and wanted to turn this off. So, he went to Tools/Options and under the Text Editor, he set those values to off.
Well, when he came in the next day and re-started SSMS, there it was again. All his changes were reverted back. He then started toying with the registry entry and went directly to the registry setting that is toggled by those GUI options:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Languages\Language Services\SQL
and set the CodeSense field to 0. If this setting is 1, it turns on Intellisense by default.
Again, it is a personal preference thing. I believe it is a great feature and will help everyone a great deal – I always loved this feature when doing development in Visual Studio or doing PL/SQL development in PL/SQL Developer.