There will be places that call code or objects on the SQL Server that are not also on the SQL Server. Sometimes, companies use more than one SQL Server, but over time the need arises for the databases on different servers to “talk” to each other. Also, there may not always be a DBA, so the application developers write SQL code into the application instead of just calling an SQL object.
Linked Servers
Why do we use linked Servers? Sometimes, databases can be put on different servers because they generally have different workloads. The hardware could have been purchased or set up specifically ...
