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:

Sybase linked server in sql 2005

How to create and configure Sybase linked server in SQL Server 2005

Reporting Services: Read Data from SSAS and SQL Server in One Dataset

Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.

Linked Server Dependencies

This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.