Make SQL Server 2008 Management Studio's Intellisense ignore case?

Question

2012-10-04：

SQL Server 2008 Management Studio has intellisense, and it is very helpful, but it is case-sensitive.

For example, I have 3 tables:

• Gy_Customer_Email
• Gy_Customer_Para
• gy_customertemp

Here's how intellisense behaves:

select * from   gy_customer       -- My input
                gy_customertemp   -- Intellisense suggestion

select * from   Gy_Customer       -- My input
                Gy_Customer_Email -- Intellisense suggestion
                Gy_Customer_Para  -- Intellisense suggestion

I want to Intellisense to display all 3 options, regardless of case. How can I do that?

2012-10-08：

Thanks for Ashley Ross!

I had installed Service Pack 1 for SQL Server Management Studio　according to your reference point, but the issue is still not resolved.

What should I do next?

My SQL Server Management Studio's option:

My SQL Server Management Studio's version

Answer 1

This issue has been reported at least two times on Microsoft Connect:

• http://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is
• http://connect.microsoft.com/SQLServer/feedback/details/402225/ssms-intellisense-make-text-matching-case-insensitive

Both issues are closed, and the problem has apparently been fixed in SQL Server 2008 R2 SP1 and in SQL Server 2012.

You should be able to install the updated SQL Server Management Studio on your development PC to resolve the problem you're having, without having to upgrade your database server.