Linked servers are frowned upon in MSSQL orchestrations as they lead to slow and buggy interactions as one tends to be crossing a domain.

What do instead? You may crosstalk across two databases if the two databases are always going to be on one server together with stored procedures. The alternative is to use SSIS ETL approaches, but these are comparatively more buggy.