July 10, 2019 at 12:14 pm
I am in the process of creating a bunch of shell databases to later restore over. In SQL 2012, when I have the explorer details page on the database level and right-click -> New Database, it creates the database and leaves me on the database level to see all the databases. In SQL 2017, it creates the database and automatically forces me down a level to see all the "bits" of the database I just created (tables, programmability, etc.).
How do I turn this behavior off? I don't want to leave the database view yet and I don't see anything in Tools -> Options that can be unclicked.
July 10, 2019 at 12:22 pm
If you press the left-arrow it goes back to the Databases node.
July 10, 2019 at 12:29 pm
I don't want to do that. I would have to do it for every single database I create. That gets really really annoying and each click takes up extra time I don't want to waste. Hence the reason I'm looking to turn the behavior off.
If it was just once or twice, I'd deal. But I'm going to be doing this a lot as I set up our new servers.
July 10, 2019 at 12:50 pm
If you are doing that many databases, wouldn't you be better off generating a script to create them? Then you'd just need one click to create them all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply