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

Articles with tag Linked Servers Rss

Search for any content tagged linked servers

   Items 1 to 5 of 5   

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 | 1,629 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: | Category: authentication
Rating: |  Discuss |   Briefcase | 7,513 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: | Category: sp_uforeach
Rating: |  Discuss |   Briefcase | 4,467 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,590 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: | Category: linked servers
Rating: |  Discuss |   Briefcase | 6,926 reads
   Items 1 to 5 of 5