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 8 of 8   
 

Test Your Linked Server Connections

Test your linked server connections and display the results.  Read more...
By Paul Andrew 2014/09/04 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,379 reads

Removing the Linked Server 2 hop Limitation

This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.  Read more...
By Derek Stanley 2013/12/17 | Source: SQLServerCentral.com | Category: authentication
Rating: |  Discuss |   Briefcase | 7,208 reads

When the reporting team needs an assist...

Collect your data from your servers easily using linked servers.  Read more...
By Robert Virag 2013/10/21 | Source: SQLServerCentral.com | Category: sp_uforeach
Rating: |  Discuss |   Briefcase | 4,333 reads

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,486 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,470 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 | 5,825 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,278 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,278 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (2)    
2 hop (1)    
administration (1)    
authentication (1)    
connectivity (1)    
distributed queries (1)    
dynamic sql (1)    
login failed for user (1)    
nt authority\anonymous logon (1)    
remote servers (1)    
sp_uforeach (1)    
testing (1)    
utility (1)