Linked Server and Verify Connection

From: Matt Tapia (mtapia_at_inbizservices.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 11:01:42 -0500

I am adding a linked server to another SQL server within a stored procedure.
I need to verify the link was made before I start running any more code. How
can I verify that I have connected successfully to the linked server?

Relevant Pages

  • Linked Server: Performance Issue with OpenQuery & SP best practices
    ... We are using the linked server feature of SQL Server 2000 to execute queries ... from the local database's stored procedure against the SQL Server database ... Please note that the schema of the remote database is different from the ...
    (microsoft.public.sqlserver.olap)
  • Re: Linked Server & XACT_ABORT
    ... calling a remote stored procedure ... escalates the local transaction to a distributed transaction. ... Wayne Snyder, MCDBA, SQL Server MVP ... > Is there anyway to set XACT_ABORT ON for a linked server? ...
    (microsoft.public.sqlserver.server)
  • Re: ODBC in Stored Procedure
    ... I don't want to use linked server. ... OLE object that you could call from a stored procedure, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: How to query two SQL Server instances
    ... SQL Server Programmer ... > I need to run a stored procedure, or make it simpler, to run a query to ... > the databases in head office? ... Then need to make it as linked server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked server execution plans
    ... > Having a stored procedure on the linked server, ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)