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.

Get Linked Server Configuration

This query will return the linked servers configuration

Linked Server Optimization

This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.

Select, Update, Delete, Insert etc.. in many servers using 1 query

Query Servers using 1 sql statement. Will make your job easy!!!