Older article/post on Linked Server functionality in SQL Server 200-2005 and 2K8.

https://jackdonnell.com/articles/linked_Serv.htm

I mostly  use the OpenQuery() select statments to get to MySQL and other platforms. Watch your security Model!