All geek questions in one place

Can I install the goto database in SQL Management Studio?

I have a connection to my database on the website, the fact is that the host also has all the other databases (thousands of them). I am blocked from all but mine, so I don’t even know why I see them.

Right now, when I connect through the connection, I have to open the Databases folder and then search for my database. I was wondering if I can just hide the others? Or make it go to mine as soon as the connection starts.

I already set the default database as mine, but it does not seem to fit into it when connected.

+4
source share
1 answer

I do not think that this can be done in an SSMS object.

Some nodes in the view tree allow you to set a filter, but this does not seem to apply to the list of databases.

See if you can force the hoster to deny VIEW ANY DATABASE permission. You can also point out the problem and assume that they simply remove this permission from the public role.

BTW in Object Explorer, typing the initial letter of your database, at least moves you to the right side of the tree (provided that they are not all named with the same initial letter, of course!), And from a quick test of this end, entering the whole name really translates you to the correct database.

+5
source

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

More articles:


All Articles