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

Ping Linked Servers From Agent Job

Ping your linked servers, send email if ping fails.  Read more...
By Ryan Loftin 2014/12/12 | Source: SQLServerCentral.com | Category: ping servers
Rating: |  Discuss |   Briefcase | 590 reads

Check Linked Servers Connectivity

Sql Script will allow you to detect when Linked Servers connection is not working, the reason why and be notify by email.  Read more...
By krystian szczyrba 2014/12/05 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 872 reads

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,500 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,285 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,347 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,507 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,490 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,918 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,297 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,297 reads
   Items 1 to 10 of 10   
 
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)    
ping servers (1)    
remote servers (1)    
sp_uforeach (1)    
testing (1)    
utility (1)