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

Content with tag Linked Server Rss

   Items 1 to 20 of 27    Older >>
 

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.  Read more...
By Vinayaka Gangadhar 2014/10/13 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 2,850 reads

Linked Server Tribulations In SQL Server

In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.   Read more...
By Thomas Knight 2014/08/05 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 5,174 reads

Show all Objects used by Linked Server

Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.  Read more...
By KILEY MILAKOVIC 2012/09/17 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 935 reads

Check connect to all linkeds

This script checks all links on the server  Read more...
By Dmitriy Ivanov 2012/07/05 | Source: SQLServerCentral.com | Category: it is launched as is.
Rating: |  Discuss |   Briefcase | 857 reads

Select, Update, Delete, Insert etc.. in many servers using 1 query

Query Servers using 1 sql statement. Will make your job easy!!!  Read more...
By Lester Policarpio 2012/03/28 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 3,286 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 2011/12/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,042 reads

A brief explanation and solution for the Double Hop problem

What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?  Read more...
By Kenneth Fisher 2011/12/09 | Source: SQLServerCentral.com | Category: double hop
Rating: |  Discuss |   Briefcase | 9,250 reads

How to Test Connectivity for a Linked Server

Just one way of testing for a linked server based on data within your database.  Read more...
By Chris Morton 2011/09/16 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,550 reads

Exec on Linked Server

By Sudhir Chawla 2010/01/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,656 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,160 reads

Get Linked Server Configuration

This query will return the linked servers configuration   Read more...
By mobasha B 2009/12/17 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 1,717 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,058 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,578 reads

On demand creation and destruction of a Linked Server for SQL Server

Create a linked server on the fly in this tip.  Read more...
By Additional Articles 2009/10/06 | Source: MSSQLTips.com | Category: linked server
Rating:  Rate this |   Briefcase | 3,180 reads

Extract Objects of a Linked Server

In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us, we need to write following query:   Read more...
By Sudhir Chawla 2009/08/07 | Source: SQLServerCentral.com | Category: linked server
Rating: (not yet rated) |  Discuss |   Briefcase | 645 reads

Sybase linked server in sql 2005

How to create and configure Sybase linked server in SQL Server 2005  Read more...
By umar iqbal 2009/07/21 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 639 reads

Monitoring group of Linked Sql Servers from a Sql Server

The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.   Read more...
By Additional Articles 2009/07/08 | Source: CodeProject.com | Category: monitoring
Rating:  Rate this |   Briefcase | 1,954 reads

Creating a Linked Server - SQL School Video

Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.  Read more...
By Andy Warren 2009/04/07 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,114 reads

Connecting Oracle BI Publisher to SQL Server

One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.  Read more...
By Additional Articles 2009/03/30 | Source: Database Journal | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 1,567 reads

Linked Server Dependencies

This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.  Read more...
By Andrew Miller-489894 2008/10/15 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 1,604 reads
   Items 1 to 20 of 27    Older >>
 
Tags
t-sql (4)    
monitoring (3)    
stored procedures (3)    
sql server 2005 (2)    
analysis services (ssas) (1)    
business intelligence (1)    
chris morton (1)    
codrakon (1)    
dependencies (1)    
double hop (1)    
it is launched as is. (1)    
it is possible to execute as regular job. (1)    
linked server sql objects (1)    
matrix (1)    
miscellaneous (1)    
mysql (1)    
oracle (1)    
performance tuning (1)    
reporting services (ssrs) (1)    
security (1)    
spn (1)    
sql server 7 (1)    
sybase linked server (1)    
tcp/ip (1)    
video (1)