Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Linked Server Rss

Search for any content tagged linked server

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 13 of 13   
 

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.  Read more...
By KILEY MILAKOVIC 2012/09/17 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 919 reads

Check connect to all linkeds

This script checks all links on the server  Read more...
By Dmitriy Ivanov 2012/07/05 | Source: SQLServerCentral.com | Category: it is launched as is.
Rating: |  Discuss |   Briefcase | 847 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,049 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,142 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,560 reads

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:   Read more...
By Sudhir Chawla 2009/08/07 | Source: SQLServerCentral.com | Category: linked server
Rating: (not yet rated) |  Discuss |   Briefcase | 641 reads

Sybase linked server in sql 2005

How to create and configure Sybase linked server in SQL Server 2005  Read more...
By umar iqbal 2009/07/21 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 638 reads

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.  Read more...
By Andrew Miller-489894 2008/10/15 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 1,579 reads

Get Linked Server Configuration

This query will return the linked servers configuration   Read more...
By mobasha B 2009/12/17 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 1,696 reads

Monitor Any Linked Server From SQL 2000

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000  Read more...
By Sakthivel Chidambaram 2008/07/11 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,428 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 2011/12/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,031 reads

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

Query Servers using 1 sql statement. Will make your job easy!!!  Read more...
By Lester Policarpio 2012/03/28 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 3,278 reads

How to Test Connectivity for a Linked Server

Just one way of testing for a linked server based on data within your database.  Read more...
By Chris Morton 2011/09/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,546 reads
   Items 1 to 13 of 13