Understanding SQL Server Linked Servers

In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.

A Linked Server Alias

Connect to Sybase with a Linked Server

Learn how to create a Linked Server to a Sybase database instance.

Changing Linked Server Passwords

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

List instances hosting similarly named databases

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

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.

On demand creation and destruction of a Linked Server for SQL Server

Create a linked server on the fly in this tip.

Extract Objects of a Linked Server

In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,

we need to write following query: