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

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 | 772 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 | 756 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,001 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,100 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,495 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 | 614 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 | 610 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,447 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,604 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,393 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 | 2,965 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,243 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,509 reads
   Items 1 to 13 of 13