Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you.

This works in SSMS, but there's an annoying problem, especially so in the table node. SSMS prefixes all table names with the schema name and a dot. To make an incremental search here, I have to type 'dbo.', followed by whatever I'm searching for. Is there an option to turn off this table name representation in SSMS?

I hope I'm asking this on the right stack exchange site. If you feel it's off base, let me know!

share|improve this question
up vote 2 down vote accepted

As far as I am aware there is no way to customise this. If you have two objects named the same but in different schemas e.g. sales.person, hr.person then there would be no way to distinguish them.

I read yesterday about which allows you to customise the tree hierarchy in SSMS. You may want to look in to that tool but I doubt it will let you do it either.

You can however right click and select Filter from the context menu, which is suspect is the closest you can get to this functionality.

share|improve this answer
I had not reflected on the fact that SSMS is actually implemented in a Visual Studio shell. As such, it's possible to extend it with add-ins, just like the product you linked to. This gave me an idea to google for SSMS and add-in. I found two really nice sites: and I'm going to accept your answer, because it led me to something usable (I found a quick-find add-in that looks promising!). Cheers! – Jörgen Sigvardsson Nov 16 '11 at 12:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.