The Intellisense drop down is case-sensitive while writing TSQL for 2008-R2. Here is a sample script to create a database and create tables
Then, type Ctrl+Shift+R to refresh the Intellisense Cache and then do a simple select
You should get a list of tables as shown below (address is after Order because of case sensitivity)
These lists are sorted case-sensitive although the server and database collations are both set to Case-Insensitive.
What do I do to fix this issue?
When you're done, playing with this db, drop it..
It appears this was reported on Microsoft Connect for SQL Server: http://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is
It is marked Fixed but from the answer it seems it will be fixed in Denali. The workaround offered seems to be just turning off Intellisense
Edit: Not to push any particular product or anything, but I have played with SQLeverywhere a few times and the intellisense in that product seems to work much better than SSMS. Although I have not tried it on databases with non-default collations set.