Of great importance is the added fact that these instances are linked as servers and they show the proper property as such in "Linked Servers" where each's catalog can be viewed.
The problem for me is that I can't specifically write a statement like this:
SELECT * FROM [COMPUTER_A\INSTANCE_01].[knowndatabase].[dbo].[knowntable]
Given the fact that INSTANCE_01 is not currently under the "USE" control within the executing interface of ssmse. Nor can I do the general sys.all_objects type of query in a loop using that same
[COMPUTER_A\INSTANCE_01].sys.all_objects
"expectation".
Is this question clear enough?
[EDIT]
An idea:
DECLARE @nullscript varchar(4000)
SET @nullscript = 'sqlcmd -S COMPUTER_A\INSTANCE_01 '
EXEC xp_cmdshell @nullscript
(to view what databases are now available):
SELECT * FROM sys.master_files WHERE data_space_id = 1
(And unfortunately unfruitful next to test):
DECLARE @nullscript2 varchar(4000)
SET @nullscript2 = 'sqlcmd -S COMPUTER_A\INSTANCE_02 '
EXEC xp_cmdshell @nullscript2
(Get the INSTANCE_01 tables .. drat):
SELECT * FROM sys.master_files WHERE data_space_id = 1
No change of the INSTANCE from _01 to _02
[END EDIT]