SQLServerCentral.com Scripts tagged Linked Server

Show all Objects used by Linked Server

Mon, 17 Sep 2012 06:00:00 UT

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.

Check connect to all linkeds

Thu, 05 Jul 2012 06:00:00 UT

This script checks all links on the server

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Synchronize all stored procedures between two servers

Tue, 15 Dec 2009 07:00:00 UT

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.

Synchronize several stored procedure between two servers

Mon, 21 Dec 2009 07:00:00 UT

Synchronize source code between two servers for multiple stored procedures

Synchronize a stored procedure between two servers

Fri, 11 Dec 2009 07:00:00 UT

Use this stored procedure to synchronize source code of a stored procedure between two servers.

Extract Objects of a Linked Server

Fri, 07 Aug 2009 06:00:00 UT

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

Tue, 21 Jul 2009 06:00:00 UT

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

Linked Server Dependencies

Wed, 15 Oct 2008 06:00:00 UT

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

Thu, 17 Dec 2009 07:00:00 UT

This query will return the linked servers configuration

Monitor Any Linked Server From SQL 2000

Fri, 11 Jul 2008 06:00:00 UT

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000

Monitor Any Linked Server From SQL 2005

Mon, 19 Dec 2011 07:00:00 UT

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005

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

Wed, 28 Mar 2012 06:00:00 UT

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

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

How to Test Connectivity for a Linked Server

Fri, 16 Sep 2011 06:00:00 UT

Just one way of testing for a linked server based on data within your database.