question

Raj More avatar image
Raj More asked

Making Intellisense Case Insensitive

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 Use master GO Create Database IntellisenseTest Go Use IntellisenseTest GO Create Table tblProductscustomer( Id Integer Identity (1,1)) Create Table tblProductsCustomerDV( Id Integer Identity (1,1)) Create Table tblProductscustomeraddress( Id Integer Identity (1,1)) Create Table tblProductscustomerOrder( Id Integer Identity (1,1)) GO Then, type **Ctrl+Shift+R** to refresh the Intellisense Cache and then do a simple select select * from IntellisenseTest.dbo. You should get a list of tables as shown below (address is after Order because of case sensitivity) ![alt text][1] 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? [1]: /upfiles/20110912_11-17-29_AM_bad_sort_order.png When you're done, playing with this db, drop it.. `Use Master; Drop Database IntellisenseTest`
sql-server-2008-r2tsqlssmsintellisense
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Shawn_Melton avatar image
Shawn_Melton answered
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][1] 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][2] 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. [1]: http://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is [2]: http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The trick being to get intellisense to stay off. I've turned mine off repeatedly (so it won't fight with red-gate sql prompt) and it just keeps going. SQLEverywhere sidesteps that nicely.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.