Post reply

Keeping the server lists in SSMS

  • May 18, 2016 at 9:35 am

    #327154

    Hello,

    Did anyone ever achieved in saving the servers frequently being used to connect via SSMS like other tools say Rapid SQL / embarcadero dbartisan have?

    Thanks.

  • May 18, 2016 at 9:45 am

    #1879914

    Yes. Use the Registered Servers window.

    John

  • May 18, 2016 at 10:00 am

    #1879918

    if servers are connected via "registered server" list, does it mean that a session will away be active using my account?

    Thanks.

  • May 19, 2016 at 1:57 am

    #1880108

    No, I don't think so - only if you're connected in Object Explorer or a query window. But try it if you're not sure.

    John

  • May 19, 2016 at 6:00 am

    #1880148

    SQL-DBA-01 (5/18/2016)

    if servers are connected via "registered server" list, does it mean that a session will away be active using my account?

    Nope, John Mitchell is right; Registered Servers or Central Management Servers give you the option to oraganzie and save connection information for multiple servers.

    that's an awesome ease of use, where you can open a query window and run something across multiple servers.

    The existance of those connections in Registered Servers/CMS don't keep open sessions, unless you added an new query, which you would see as another query panel in SSMS

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply