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

Content with tag Linked Servers Rss

   Items 1 to 5 of 5   
 

How to join a local table to a remote table by way of a linked server

Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.  Read more...
By Stan Kulp 2012/02/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,301 reads

Ping Linked servers

This script will ping the linked server and see if there alive  Read more...
By Mark Huber 2011/11/02 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 1,324 reads

Setting up linked servers with an out-of-process OLEDB provider

There is an inprocess setting for linked servers. Have you ever used it? Gianluca Sartori gives a look at what the implications are for this.  Read more...
By Gianluca Sartori 2011/06/09 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 4,936 reads

Linked Server Connectivity Test

A short procedure for your tools database. Use it to test connectivity to linked servers.  Read more...
By Richard Doering 2010/12/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,098 reads

Linked Server Connectivity Test

A short procedure for your tools database. Use it to test connectivity to linked servers.  Read more...
By Richard Doering 2010/12/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,098 reads
   Items 1 to 5 of 5   
 
Tags
t-sql (2)    
administration (1)    
connectivity (1)    
distributed queries (1)    
remote servers (1)    
utility (1)