All geek questions in one place

Is there a way to hide the schema or at least the aspnet procedures from the list of Sql Server Management Studio processes?

I think the question speaks for itself, but I'm tired of scrolling through the list of procedures, filled with 50 aspnet procedures.

Is there a way to hide the dbo schema or these procedures from the list?

Is there any other / equivalent tool that would allow me to do this?

With TOAD, I could open each circuit myself - that would be great!

My only other option is to link our membership provider to a different database, not the rest. In general, this is not a big deal, but I decided that I would ask instead of getting more upset.

+4
source share
2 answers

In SSMS 2005 or 2008, right-click on "Stored Procedures", then on "Filter Settings", then for "Schema" change "Operator" to "Does Not Contain", and then set the value to filter them.

+3
source

There is a way in SQL 2008. It may also be in 2005. If you right-click the Stored Procedures folder in the SSMS Object Explorer, you will see the Filter menu item. You can create a filter that displays only saved processes that you want to view. You can filter the name, scheme, owner and creation date

+3
source

Source: https://habr.com/ru/post/1300332/

More articles:


All Articles