sp_addlinkedserver (Looks a bit complicated…)
Linked servers and their aliases will be displayed in Server Objects, Linked
SELECT TOP 10 * FROM [BOB].addresses.dbo.postcode_district WITH(NOLOCK)
In this example:
BOB is the alias of the Linked Server.
addresses is the name of the remote database.
postcode_district is the name of the table.