Intellisense only works if you are connected to a database that is SQL2008 or higher.  If you use management studio to connect to a sql2000 or sql2005 server, there will be no intellisense.

Also, there is an option to turn it on/off.  In SQL Server Management Studio, click Tools -> Options. Expand "Text Editor" and click on "All Languages".  Make suer "Auto list members and Parameter information" are both checked.

Does SQL Server 2008 R2 Express have Intellisense?
Take a passage like this:



Fill in the blank: Each of these boxes denote a ______

Is there a single general term for these that's better than note or chord? Or maybe there's a term for "anything that has a duration" that also encompasses rests? It seems like enough of a fundamental concept that it should have a name.
