Linked servers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick Charnes (rickxyz--nospam.zyxcharnes_at_yahoo.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 09:17:33 -0500

Using SQL 2000, we have been using the linked server functionality to
connect two databases that up till now have resided on two separate
servers. Our network people have now moved those databases so they are
on the same server. Can we continue to use Linked Servers to pass
queries back and forth? (I know we don't HAVE to, but I need to know if
we CAN.) Thanks.

Relevant Pages

  • Re: Executing INSERT INTO EXEC against linled server
    ... "Steve Kass" wrote in message ... > Igor Marchenko wrote: ... >>>>collect list of the databases and RECOVERY MODEL from linked server. ...
    (microsoft.public.sqlserver.programming)
  • sql2k: ole db timeout
    ... file etc which restores the db. ... This works fine for databases lets say under ... When I check the linked server that database that was to be ...
    (microsoft.public.sqlserver.programming)
  • Re: OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not wo
    ... I understand that when you run delete/update query via linked server to ... AS400 databases, you receive errors from OLE DB Provider. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Problem after disaster recovery
    ... recover all the databases including the system databases. ... There are a number of views in the database which use a linked server ... Additionally I can drop the views but I cannot recreate the views. ...
    (microsoft.public.sqlserver.security)
  • Problem after disaster recovery
    ... recover all the databases including the system databases. ... There are a number of views in the database which use a linked server named ... Additionally I can drop the views but I cannot recreate the views. ...
    (microsoft.public.sqlserver.security)