How a number of environments on different servers and databases,
make a linked server object 'Target' that I change the datasrc on via a stored proc to 're-point' my scripts

what I want to be able to is to reference the default catalogue I set in my linked server via a query


Select * From LinkedServer.DefaultCatalogue.dbo.MyTable

using openquery() seems to be the only thing that will work so far but I want to avoid having to encapsulate my entire query as text

Any suggestions?