Getting Filters to Stick

[BoulderBum]

When you right click a folder like "Tables" you can set a filter so you only see certain tables.

I use this feature a lot to filter out any tables containing the text aspnet which pertain to ASP.NET membership tables I don't care about.

My only annoyance is that every time I re-open SSMS, it makes me re-apply the filter.

Is there any way to make the filter stick or apply itself by default?

 

[mrdenny]

Not that I've found. I beleive that it's only good on the current session of the GUI.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

The closest thing I can think of is to stick all the tables having to do with the ASP .Net stuff under a different schema. Then create a non-SysAdmin account with SELECT rights to the original schema (I'm assuming dbo) and log in with that account.

Unfortunately, SysAdmin accounts see all schemas, so it won't work if you are logging in with a SysAdmin account.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"