SSMS: Allow forcing case-insensitive matching in Object Explorer filters
In SSMS, when filtering objects in Object Explorer, comparisons on string properties (e.g. Name) use the collation of the database or instance, depending on whether you are filtering database-level or instance-level meta-data, respectively. Hence, when either level is using either a case-sensitive or binary collation, it is not possible to do a case-insensitive search of objects at that level. Having a "case-insensitive" check-box per each filterable Property would be super awesome 😺. Even better might be a "flip case sensitivity" check-box that would then also make it a case-sensitive comparison in an otherwise case-insensitive context.
This situation lead to the following question on DBA.StackExchange, and my answer which was to make use of a SQL Injection bug I found while researching the question:
SSMS - How to do case-insensitive searches in Object Explorer ( https://dba.stackexchange.com/a/228324/30859 )
Thanks for filing this request. We’ll take a look at it and prioritize.