I have sql 2012 installed on my laptop. I have about 5 production instances of sql.
I want to be able to query and join all my instances from my laptop while only logged into the laptop instance.
I found some instructions on this but tried and failed. Does anyone have a good outline on how to complete this.
if someone would fill in the command with some example hosts/instance/database names that would help
source one laptop - host = lap1 instance = lap1 db=weather
source two production server 1 host = serv1 instance=serv1 db = weather
source three production server 2 host = serv2 instance = serv2 db= weather
all the names have been changed for cleansing purposes, but should appropriately define the logic
side question 2
I connect my locally installed ssms to two instances of of sql. once I start querying in one instance, I am unable to change the focus of the drop down box to any of the db's on the other server. I am stuck in one. This is even after I highlight the dern server.