Menu
I use Microsoft SQL Server Management Studio a lot. Every time I'm starting the tool, I'll need to connect to a server. Every day I'll need to connect to the same 4 servers. Is there a ways to "save" the servers in a file, so that I don't need to connect them every time I restart the tool.
It would be great if I could save some SQL scripts save into that file as well. Is this possible?
593
Under the "View" menu, select "Registered Servers", and a new panel will appear. You can save servers in "Local Server Groups" (which is under "Database Engine") by right-clicking and selecting "New Server Registration". You can also select "New Server Group" if you want to organize your servers into groups.
To save a query: Use the Save command in the application toolbar. In the Save File As window, choose a name and a location to save your query.
As soon as you start SQL Server Management Studio (SSMS) the Object Explorer should open. If not then you can open it by one of the following ways: Pressing the shortcut key F8. From the menus select View > Object Explorer as shown below.
saved in "C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\". Now open SSMS 2016 and you should see all of your old connections from SSMS 2014.
Open "Registered Servers" from the "View" menu and persist them there?
170
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
