Mar 28 2024 06:06 AM
I am usually connected to one Object, which appears automatically whenever I start MSSMS, but recently I've started using a secondary Object. I can be connected to both in one session, and can run queries on either, but I lose one of them when I close the program.
The next time I start MSSMS again, only one of them will show up, and I have to re-connect to the other one.
Is there a way to make sure both Objects are connected to each time I start the program?
Apr 01 2024 10:48 PM
Apr 02 2024 01:16 AM
On the Objects Explorer, it shows which databases you're connected to. The censored one in the screenshot below.
It only keeps one connection after I close the program, whereas I routinely use two, so would like to keep both on program restart.
Apr 02 2024 04:21 AM
@Sevoris , that's the normal behaviour of SSMS, but for a quick access you can use Register Servers - SQL Server Management Studio (SSMS) | Microsoft Learn
Apr 03 2024 12:45 AM