SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Linked Servers Rss

Search for any content tagged linked servers

   Items 1 to 6 of 6   

Changing Linked Server Properties

A quick guide on changing the linked server properties and settings.  Read more...
By David Fundakowski 2016/07/07 | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 2,970 reads

System Stored Procedures for SQL Azure Linked Servers

Microsoft released the preview version of Azure SQL Database V12 in December of 2014. As a database administrator, you might wonder about the schema and security of these new data marts. Microsoft has supplied system stored procedures for the database developer to query the Linked Servers for this type of meta data, as John Miner explains.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,185 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,589 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,502 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,661 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 | 7,178 reads
   Items 1 to 6 of 6