SQL Server Management Studio Schema View

Question

I'm working with a SQL server and several databases. Each database may have many schema's, such as dbo., admin., other., and I'm getting tired of scrolling around trying to find things.

If I'm working on a schema specific project, I want to filter out everything else from my view except that schema. As dbo, I see everything which means I spend the majority of my day molesting my scroll wheel (that is a joke).

Is this possible in SQL Server Management Studio 2008?

Answer 1

In SSMS 2005 or 2008, right click on the heading: "Stored Procedures", "Tables", etc, then on "Filter Settings", then for the "Schema" change "Operator" to "Does not contain" or "Contains", etc and then set a Value to filter them...

Answer 2

Yes: don't connect as db_owner or "sa".

Connect as a user that can access and change the desired schema only.

This way, the engine "Metadata visibility" will do it automatically