RE: Linked Server setups

From: Deepak (anonymous_at_discussions.microsoft.com)
Date: 04/21/04


Date: Wed, 21 Apr 2004 16:16:04 -0700

Hi Thomas,
Execute sp_linkedservers. This will give you all the details you want about the linked servers.

Regards

Deepak
[I Code, therefore I am]

     
     ----- Thomas Scheiderich wrote: -----
     
     I have set up a linked server that I am having problems with on my Sql
     Server 7.0 server
     
     Where do I look to see what linked servers are defined as well as what
     the path to the data is (in this case it is an Access database).
     
     Thanks,
     
     Tom.
     
     



Relevant Pages

  • Re: Passing Parameters through a linked server?
    ... Are you able to execute this without linked servers in picture? ... > @ID int OUTPUT ...
    (microsoft.public.dotnet.framework.adonet)
  • executinga sp using linked server gives an error
    ... Linked servers are connected using following syntax.. ... EXECUTE.databasename.dba.PickupWeight_SP ... >BEGIN DISTRIBUTED TRANSACTION ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked Server setups
    ... Deepak wrote: ... This will give you all the details you want about the linked servers. ... > Tom. ...
    (microsoft.public.sqlserver.programming)
  • login failed for user "null"
    ... I have problem with linked servers (MS SQL Server 2k)- when I try to execute ... Network Protocols is TCP/IP. ...
    (microsoft.public.sqlserver.security)
  • RE: Select version from linked server
    ... Not nerar one of our linked servers now, ... > I´m trying to get the MSSQL Server version of my DBServers, ... > Thanks and best regards ...
    (microsoft.public.sqlserver.server)