Post reply

SSMS v18.10 connecting and running query on ALL my SQL Server registrations

  • March 3, 2022 at 12:09 pm

    #3992281

    When I open a .sql file in SSMS it takes quite a while and appears to be connecting to all my SQL Server registrations --- then when I execute the query it attempts to run against all my SQL Server registrations.

    When I manually change the connection to a specific SQL Server, the problem is resolved.

    How can I change my SSMS so that only 1 server connection applies when I open my file/query?

     

    BT

  • March 3, 2022 at 2:04 pm

    #3992448

    Do you have a server connection open in Object Explorer when you open the file? Is the server group selected rather than a specific server connection when you open the file?

    Open the file in the context of a query window attached to the server to which you want to query.

  • March 3, 2022 at 2:13 pm

    #3992450

    thx , makes sense-- I will be sure to connect to an instance prior to opening the .sql file in SSMS...

    BT

Viewing 3 posts - 1 through 2 (of 2 total)

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