TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources

TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).

Changing Linked Server Passwords

How to article on changing passwords for linked servers via TSQL and SSMS.

Changing a Linked Server Name

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.

Part 2 -- Restore a database to another instance...

This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.

Linked Server Tribulations In SQL Server

In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.

Show all Objects used by Linked Server

Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.