I use SQL Server Management Studio Express to work in several databases. What gets annoying, is that the databases I work in have 30+ tables in them, only 5-10 of which I actually work with. Then there's the stored procedures I have to sort through to find the ones that I need and so on. I set filters so that I see only what is applicable to me, but I hate having to set those filters every time I start Management Studio back up. Is there a way to save my settings so that it opens the same way every time? I've looked around and can't find an answer to this.
Thanks!
Hi Kevin,
Sorry, but the filters cannot be saved in SQL Server Management Studio. The filter is used temporarily for us to get objects we need.
You may create the objects under some special schema and sort by schema, so that you can find them more quickly.
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
No comments:
Post a Comment